Sets the maximum number of rows that can be returned per SQL query issued on behalf of an Essbase query.
HAMAXQUERYROWS [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—Determines the maximum number of rows retrieved per SQL query. The default is zero, meaning that no row limit is applied.
This setting determines the maximum number of rows retrieved per SQL query issued on behalf of an Essbase query. HAMAXQUERYROWS is a specific limit to an Essbase query. The setting provides a way of controlling queries that retrieve too much data.
An important distinction exists between the purposes of HAMAXQUERYROWS and HARETRIEVENUMROW. Whereas HAMAXQUERYROWS controls the number of total rows to return, HARETRIEVENUMROW affects memory consumption by controlling how many rows to process at one time.
HAMAXQUERYROWS and HARETRIEVENUMROW 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, Essbase processes up to 100,000 rows per SQL query.
HAMAXQUERYROWS 100000