Sets the maximum number of rows resulting from an SQL query to process at one time.
HARETRIEVENUMROW [appname [dbname]] n
appname—Optional. If you supply an application name, the setting applies to all databases within the named application. If you do not supply an application name, the setting applies to all applications and databases on the Essbase Server.
dbname—Optional. If you supply a database name and an application name, the setting applies only to the named database. If you do not also provide an application name, the database is ignored and the setting applies to all applications and databases on the Essbase Server.
n—The value of n specifies how many rows to process at a time. The default is 100.
This setting sets the number of rows to process at a time. A low value may degrade performance and increase query time, but reduce memory usage.
An important distinction exists between the purposes of HARETRIEVENUMROW and HAMAXQUERYROWS. Whereas HARETRIEVENUMROW affects memory consumption by controlling how many rows to process at one time, HAMAXQUERYROWS controls the number of total rows to return.
HARETRIEVENUMROW and HAMAXQUERYROWS should not be confused with QRYGOVEXECBLK which sets the maximum number of blocks that a query can access before the query is terminated.
In the following example, an Essbase query processes rows from each SQL query in sets of 50 rows.
HARETRIEVENUMROW 50