MAINTAINING THE DOMINO AND DB2 ENVIRONMENT
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:
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