DisableKeysetCursor CLI/ODBC and IBM data server driver configuration keyword
Disables keyset-driven scrollable cursors.
- db2cli.ini keyword syntax:
- DisableKeysetCursor = 0 | 1
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="DisableKeysetCursor" value="0 | 1"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- Keyset-driven scrollable cursors are returned when requested.
- Usage notes:
When set to 1, this keyword forces the CLI driver to return a static cursor to the application, even if the application has requested a keyset-driven scrollable cursor. The default setting (0) causes keyset-driven cursors to be returned when the application requests them. This keyword can be used to restore behavior before scrollable cursors were supported.