HAMAXQUERYROWS

Sets the maximum number of rows that can be returned per SQL query issued on behalf of an Analytic Services query.

Syntax

HAMAXQUERYROWS [appname [dbname]] n

 appname Optional parameter. 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 Analytic Server.
 dbname Optional parameter. 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 Analytic Server.
n The value of n determines the maximum number of rows retrieved per SQL query. The default is zero, meaning that no row limit is applied.

Description

This setting determines the maximum number of rows retrieved per SQL query issued on behalf of an Analytic Services query. HAMAXQUERYROWS is a specific limit to an Analytic Services query. The setting provides a way of controlling queries that retrieve too much data.

Notes

Example

In the following example, Analytic Services processes up to 100,000 rows per SQL query.

HAMAXQUERYROWS 100000

See Also

HAMAXNUMSQLQUERY
HARETRIEVENUMROW
QRYGOVEXECBLK
QRYGOVEXECTIME

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com