CursorTypes CLI/ODBC and IBM data server driver driver configuration keyword

Specifies which cursor types are permitted.

db2cli.ini keyword syntax:
CursorTypes = 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7
IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
<parameter name="CursorTypes" value="0 | 1 | 2 | 3 | 4 | 5 | 6 | 7"/>
Attention: The IBM data server driver configuration file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
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()