EDIT_MAX_ROWS

Read syntax diagramSkip visual syntax diagram
                  .-0-.   
>>-EDIT_MAX_ROWS=-+-n-+----------------------------------------><

EDIT_MAX_ROWS
Controls the maximum number of rows that can be loaded into any ZDT/Db2 editor session, and can be used to disable "large" table support.
The default is 0, meaning that:
  • "Large" editor mode is available to all ZDT/Db2 users. If a ZDT/Db2 user specifies row count = 0 for an editor-related function, ZDT/Db2 may use a scrollable cursor to access Db2® data. This might require Db2 to build a copy of the result table in a Db2 temporary database.
  • "Normal" editor mode is available to all ZDT/Db2 users. An ZDT/Db2 user can specify row count = n, n>0 for an editor-related function, ZDT/Db2 attempts to load up to n rows into the ZDT/Db2 editor session. There is no restriction on the value n that can be specified up to a maximum of 2G-1.
Specify a positive value (nn) to:
  • Disable "large" editor mode. If a ZDT/Db2 user specifies row count = 0 for an editor-related function, ZDT/Db2 ignores the 0 value, the resulting ZDT/Db2 editor session is a "normal" edit session and ZDT/Db2 loads at most nn rows.
  • Set an absolute limit on the number of rows that any ZDT/Db2 can process in a ZDT/Db2 editor session. If a ZDT/Db2 user specifies row count = m, m>nn on a function entry panel, ZDT/Db2 ignores the m value and loads at most nn rows into the editor.
Tip:
  • Specify a large value (for example, 2,000,000,000) to disable "large" editor mode, while setting no reasonable upper limit to the number of rows that can be loaded into a ZDT/Db2 editor session.
  • Specify a modest value (for example, 10,000) to limit TSO memory usage when using the ZDT/Db2 editor.