MAINTAINING THE DOMINO AND DB2 ENVIRONMENT


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 IBM® DB2 Universal Database™ Enterprise Server Edition enabled IBM® Lotus® 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.

Related topics