Large table options

You can set the Scrollable cursor type option on the Editor Options (2 of 8) panel to either 1 (Insensitive) or 2 (Sensitive static). When processing a large Db2® object in place holder mode only, FM/Db2 uses the appropriate type of scrollable cursor. There is no simple method for you to determine which type of scrollable cursor is in use. A DBG trace shows the SQL statement used to declare the cursor and fetch the data.

Related references