ibmcognos.maxRowsRetrieved

The ibmcognos.maxRowsRetrieved property on a data server connection can be used to set the maximum number of rows that are returned in an SQL query.

This property is applicable for the dynamic query mode (DQM) only, and can be used to prevent users from executing queries which retrieve large numbers of rows from the database server.

Use the following syntax to specify this property, where N represents the maximum number of rows to return:

ibmcognos.maxRowsRetrieved=N

The N value must be an integer greater than 0 and less or equal to 2147483647.

An exception is thrown if an invalid value is detected. By default, no limit is applied to the number of rows that are returned.

Not setting this property, or setting it to 0, means that there is no limit.