Specifies which cursor types are permitted.
- db2cli.ini keyword syntax:
- CursorTypes = 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7
- Default setting:
- Forward-only, static, keyset-driven, and dynamic cursors are supported
if the server supports them.
- Usage notes:
-
The CursorTypes keyword is a bitmask that indicates what types
of cursors an application can open:
- 0x0 - forward-only (can always be opened)
- 0x1 - static
- 0x2 - keyset-driven
- 0x4 - dynamic
For example,
- to prevent applications from opening dynamic scrollable cursors, set CursorTypes
to 3.
- to allow applications to open only non-scrollable cursors, set CursorTypes
to 0.
This keyword only affects calls made to the following
CLI functions:
- SQLBulkOperations()
- SQLExecDirect()
- SQLExecute()
- SQLFetchScroll()
- SQLPrepare()
- SQLSetPos()