In addition to command states, Client-Library keeps track of initiated commands. An initiated command can be in any one of the following states:
Initiated command state |
Meaning |
|---|---|
Idle |
The application either has not yet initiated a command or has completely processed the results of the last command. |
Idle, with declared cursor |
The application initiated a cursor-declare command (ct_cursor(CS_CURSOR_DECLARE)), sent the command to the server, and completely processed the results. |
Idle, with opened cursor |
The application initiated a cursor-open command (ct_cursor(CS_CURSOR_OPEN)), sent the command, and fetched all the results (ct_results returned CS_END_RESULTS), but has not yet closed the cursor. |
Opened cursor, no rows fetched |
The application called ct_results but has not yet processed any of the results. |
Opened cursor, fetching rows |
The application called ct_fetch at least once and is currently in the process of fetching results. |
ct_command command initiated |
The application initiated a language, message, package, or RPC command using ct_command. |
Initiated send-data |
The application initiated a send-data or send-bulk-data command using ct_command. |
Initiated cursor-declare |
The application initiated a cursor-declare command (ct_cursor(CS_CURSOR_DECLARE)) but has not yet sent it to a server using ct_send. |
Initiated cursor-rows |
The application initiated a cursor-rows command using ct_cursor(CS_CURSOR_ROWS). |
Initiated cursor-open |
The application initiated a cursor-open command (ct_cursor(CS_CURSOR_OPEN)) but has not yet sent it to a server. |
Initiated cursor-close |
The application initiated a cursor-close command (ct_cursor(CS_CURSOR_CLOSE)) but has not yet sent it to a server. |
Initiated cursor-deallocate |
The application initiated a cursor-deallocate command (ct_cursor(CS_CURSOR_DEALLOC)) but has not yet sent it to a server. |
Initiated cursor-update |
The application initiated a cursor-update command (ct_cursor(CS_CURSOR_UPDATE)) but has not yet sent it to a server. |
Initiated cursor-delete row |
The application initiated a cursor-delete command (ct_cursor(CS_CURSOR_DELETE)) but has not yet sent it to a server. |
Initiated dynamic cursor- declare |
The application initiated a cursor-declare command on a prepared dynamic SQL statement (ct_dynamic(CS_CURSOR_DECLARE)) but has not yet sent it to a server. |
Initiated dynamic deallocate |
The application initiated a command to deallocate a prepared SQL statement (ct_dynamic(CS_DEALLOC)) but has not yet sent it to a server. |
Initiated dynamic describe |
The application initiated a command to retrieve input parameter information (ct_dynamic(CS_DESCRIBE_INPUT)) or column list information (ct_dynamic(CS_DESCRIBE_OUTPUT)) but has not yet sent it to a server. |
Initiated dynamic execute |
The application initiated a command to execute a prepared SQL statement (ct_dynamic(CS_EXECUTE)) but has not yet sent it to a server. |
Initiated dynamic execute immediate |
The application initiated a command to execute a literal SQL statement (ct_dynamic(CS_EXEC_IMMEDIATE)) but has not yet sent it to a server. |
Initiated dynamic prepare |
The application initiated a command to prepare a SQL statement (ct_dynamic(CS_PREPARE)) but has not yet sent it to a server. |
ct_send_data succeeded |
The application successfully called ct_send_data at least once. |
Initiated send-bulk command |
The application initiated a send-bulk-data command (ct_command(CS_SEND_BULK_CMD)) but has not yet sent it to a server. |
