Detailed information for the notes.ini Keyword: 

DB2QueryViewRowLimit


Short Description: Specifies the maximum number of rows returned by an SQL query

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.

 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.





Default value:
None

Syntax:
DB2QueryViewRowLimit=value

Example:
DB2QueryViewRowLimit=500

UI equivalent:
None at the server level.


Applies to:
Server


Valid for version:
7.0.0

Documented in:
Lotus Domino Administrator 7 Help

Entry created by:
Bastian W.