Description: Specifies the maximum number of rows returned by an SQL query when using query views in Domino Designer. This setting must be added manually. It is not automatically added to the NOTES.INI file after the DB2 Enablement Tool is run on a Domino server.
Applies to: Server
Default: 500
UI equivalent: None at the server level. However, on DB2-enabled 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.
See also