CURSOR_DESC structure

A CURSOR_DESC structure contains information about a cursor, including the following:

• The cursor’s unique ID

• The type of cursor command most recently issued by the client

• The status of the cursor

A CURSOR_DESC structure is defined in SYGWPLI as follows:

CURSOR_ID                FIXED BIN(31),
NUMBER_OF_UPDATE_COLUMNS FIXED BIN(31),
FETCH_COUNT              FIXED BIN(31),
CURSOR_STATUS            FIXED BIN(31),
CURSOR_COMMAND           FIXED BIN(31),
COMMAND_OPTIONS          FIXED BIN(31),
FETCH_TYPE               FIXED BIN(31),
ROW_OFFSET               FIXED BIN(31),
CURSOR_NAME_LENGTH       FIXED BIN(31),
CURSOR_NAME              CHAR(30),
TABLE_NAME_LENGTH        FIXED BIN(31),
TABLE_NAME               CHAR(30);