Intermediate Row Limit

The Intermediate Row Limit VLDB property is used to limit the number of rows of data returned to the server from pure SELECT statements issued apart from the final pass. Apart from the final pass, pure SELECT statements are usually executed if there are analytical functions or partition pre-queries to process. Since the partition pre-queries return only a handful of rows, the SELECT statements issued for analytical function processing decide the number of rows set in most cases. If the limit is exceeded, the report fails with an error message. When it is set to the default, the Intermediate Row Limit takes the value of the Result Set Row Limit VLDB property at the report (highest) level.

The table below explains the possible values and their behavior:

Value	Behavior
0	No limit on number of rows returned
Number	Number of rows returned is limited to the specified number