AllowedCursorTypes IBM data server driver configuration keyword
Specifies permitted cursor types.
- Equivalent CLI keyword
- CursorTypes
- Equivalent IBM® Data Server Provider for .NET connection string keyword
- N/A
- db2dsdriver.cfg configuration syntax
<parameter name="AllowedCursorTypes" value="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 AllowedCursorTypes 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
- to prevent applications from opening dynamic scrollable cursors, set AllowedCursorTypes to 3.
- to allow applications to open only nonscrollable cursors, set AllowedCursorTypes to 0.
This keyword only affects calls made to the listed functions:SQLBulkOperations()SQLExecDirect()SQLExecute()SQLFetchScroll()SQLPrepare()SQLSetPos()