EDIT_MAX_ROWS


1 EDIT_MAX_ROWS=
2.1! 0
2.1 n
EDIT_MAX_ROWS
Controls the maximum number of rows that can be loaded into any FM/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 FM/Db2 users. If a File Manager/Db2 user specifies row count = 0 for an editor-related function, FM/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 FM/Db2 users. An FM/Db2 user can specify row count = n, n>0 for an editor-related function, FM/Db2 attempts to load up to n rows into the FM/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 File Manager/Db2 user specifies row count = 0 for an editor-related function, FM/Db2 ignores the 0 value, the resulting FM/Db2 editor session is a "normal" edit session and FM/Db2 loads at most nn rows.
  • Set an absolute limit on the number of rows that any FM/Db2 can process in a File Manager/Db2 editor session. If a File Manager/Db2 user specifies row count = m, m>nn on a function entry panel, FM/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 File Manager/Db2 editor session.
  • Specify a modest value (for example, 10,000) to limit TSO memory usage when using the FM/Db2 editor.