DOMINO AND DB2

Setting the maximum number of rows in SQL queries
By default, the maximum number of rows returned by an SQL query is 500 rows. You can use the NOTES.INI setting, DB2QUERYVIEWROWLIMIT=value to specify the maximum allowable number of rows returned by an SQL query when using Query Views on the associated server.

To set the maximum number of rows returned in SQL queries to a value other than 500, add this NOTES.INI variable to server's NOTES.INI file:


The default setting is DB2QUERYVIEWROWLIMIT=500

Note On DB2-enabled Domino servers, designers can set "Maximum rows returned by an SQL query" in the View Properties - Option tab. If the DB2QueryViewRowLimit variable is set at the server level, designers can still limit the number of rows to a smaller value, and the smaller value will take precedence.

For more information about NOTES.INI variables, see the topic NOTES.INI Settings.

See also