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