The new SRV_CURDESC2 scrollable cursor structure in Open Server is a superset of the SRV_CURDESC cursor structure.
There are two additional fields in the SRV_CURDESC2 structure:
currow_pos describes the current row position of a cursor.
curtotalrowcount describes the total number of rows in the result set; curtotalrowcount only applies to insensitive, scrollable cursors.
The following new cursor declare options are available in the curstatus field in SRV_CURDESC2:
CS_CURSTAT_SCROLLABLE specifies a read-only, insensitive scrollable cursor.
CS_CURSTAT_INSENSITIVE specifies 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 specifies a read-only, semi-sensitive, scrollable cursor. When such a cursor is specified, CS_CURSTAT_SCROLLABLE must also be enabled.