Callable routines for initiated commands

Table A-4 maps each initiated command state to the Client-Library routines that an application can call while in that state.

Where “none” is specified, an application can call none of the routines listed under “Initiated command routines”. From states that map to a “none” value in the Callable Routines column, an application’s options are to send (ct_send) or cancel (ct_cancel) the initiated command.

Table A-4: Callable routines for initiated command states

Initiated Command

Callable Routines

Idle

ct_cmd_drop ct_command(CS_LANG_CMD) ct_command(CS_MSG_CMD) ct_command(CS_PACKAGE_CMD) ct_command(CS_RPC_CMD) ct_command(CS_SEND_BULK_CMD) ct_command(CS_SEND_DATA_CMD) ct_command(CS_SEND_DATA_NOCMD) ct_cursor(CS_CURSOR_DECLARE) ct_dynamic(CS_CURSOR_DECLARE) ct_dynamic(CS_DEALLOC) ct_dynamic(CS_DESCRIBE_INPUT) ct_dynamic(CS_DESCRIBE_OUTPUT) ct_dynamic(CS_EXECUTE) ct_dynamic(CS_EXEC_IMMEDIATE) ct_dynamic(CS_PREPARE) ct_sendpassthru

Idle, with declared cursor

ct_cursor(CS_CURSOR_ROWS) ct_cursor(CS_CURSOR_OPEN) ct_cursor(CS_CURSOR_CLOSE, CS_DEALLOC) ct_cursor(CS_CURSOR_DEALLOC) ct_dynamic(CS_DEALLOC)

Idle, with opened cursor

ct_cursor(CS_CURSOR_CLOSE) ct_cursor(CS_CURSOR_CLOSE, CS_DEALLOC) ct_dynamic(CS_DEALLOC)

Opened cursor, no rows fetched

ct_cursor(CS_CURSOR_CLOSE) ct_cursor(CS_CURSOR_CLOSE, CS_DEALLOC)

Opened cursor, fetching rows

ct_cursor(CS_CURSOR_CLOSE) ct_cursor(CS_CURSOR_CLOSE, CS_DEALLOC) ct_cursor(CS_CURSOR_UPDATE) ct_cursor(CS_CURSOR_DELETE)

ct_command command initiated

ct_dyndesc(CS_USE_DESC) ct_dynsqlda(CS_SQLDA_PARAM) ct_param ct_setparam

Initiated send-data

ct_data_info(CS_SET) ct_send_data

Initiated cursor-declare

ct_cursor(CS_CURSOR_ROWS) ct_cursor(CS_CURSOR_OPEN) ct_cursor(CS_CURSOR_OPTION) ct_dyndesc(CS_USE_DESC) ct_dynsqlda(CS_SQLDA_PARAM) ct_param ct_setparam

Initiated cursor-rows

ct_cursor(CS_CURSOR_OPEN)

Initiated cursor-open

ct_dyndesc(CS_USE_DESC) ct_dynsqlda(CS_SQLDA_PARAM) ct_param ct_setparam

Initiated cursor-close

None

Initiated cursor-deallocate

None

Initiated cursor-update

ct_dyndesc(CS_USE_DESC) ct_dynsqlda(CS_SQLDA_PARAM) ct_param ct_setparam

Initiated cursor-delete

None

Initiated dynamic cursor- declare

None

Initiated dynamic deallocate

None

Initiated dynamic describe

None

Initiated dynamic execute

ct_dyndesc(CS_USE_DESC) ct_dynsqlda(CS_SQLDA_PARAM) ct_param ct_setparam

Initiated dynamic execute immediate

None

Initiated dynamic prepare

ct_dyndesc(CS_USE_DESC) ct_dynsqlda(CS_SQLDA_PARAM) ct_param ct_setparam

ct_send_data succeeded

ct_send_data

Initiated send-bulk command

ct_send_data