Values for curstatus

In addition to options described in Table 2-13, the following cursor declare options are available in the curstatus field in SRV_CURDESC2:

Table 2-17: Values for curstatus (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.