In addition to options described in Table 2-13, the following cursor declare options are available in the curstatus field in SRV_CURDESC2:
Value |
Meaning |
|---|---|
CS_CURSTAT _SCROLLABLE |
A read-only, insensitive scrollable cursor. |
CS_CURSTAT _INSENSITIVE |
A read-only, non-scrollable, insensitive cursor. When such a cursor is specified, CS_CURSTAT_INSENSITIVE must be enabled, and CS_CURSTAT_SCROLLABLE must be disabled. When an insensitive, scrollable cursor is specified, both CS_CURSTAT_INSENSITIVE and CS_CURSTAT_SCROLLABLE must be enabled. |
CS_CURSTAT _SEMISENSITIVE |
A read-only, semi-sensitive, scrollable cursor. When such a cursor is specified, CS_CURSTAT_SCROLLABLE must also be enabled. |
CS_CUR_RELLOCKS_ONCLOSE |
The cursor was closed and the shared read locks are released. |
