cci_execute

Description

The cci_execute function executes the SQL statement (prepared statement) that has executed cci_prepare(). A request handle, flag, the maximum length of a column to be fetched, and the address of a T_CCI_ERROR construct variable in which error information being stored are specified as arguments.

The function of retrieving the query result from the server by configuring flag can be classified as synchronous or asynchronous. Or it can be determined whether to execute multiple queries or one query. If the flag is set to CCI_EXEC_QUERY_ALL, a synchronous mode (sync_mode) is used to retrieve query results immediately after executing prepared queries if it is set to CCI_EXEC_ASYNC, an asynchronous mode (async_mode) is used to retrieve the result immediately each time a query result is created. The flag is set to CCI_EXEC_QUERY_ALL by default, and in such cases the following rules are applied.

• The return value is the result of the first query.
• If an error occurs in any query, the execution is processed as a failure.
• For a query composed of in a query composed of q1; q2; q3 if an error occurs in q2 after q1 succeeds the execution, the result of q1 remains valid. That is, the previous successful query executions are not rolled back when an error occurs.
• If a query is executed successfully, the result of the second query can be obtained using cci_next_result().

max_col_size is a value that is used to determine the maximum length of a column to be sent to a client when the columns of the prepared statement are CHAR, VARCHAR, NCHAR, VARNCHAR, BIT or VARBIT. If this value is 0, full length is fetched.

Syntax

int cci_execute(int req_handle, char flag, int max_col_size, T_CCI_ERROR *err_buf)

• req_handle: (IN) Request handle of the prepared statement
• flag: (IN) Exec flag (CCI_EXEC_ASYNC or CCI_EXEC_QUERY_ALL)
• max_col_size: (IN) The maximum length of a column to be fetched when it is a string data type in bytes. If this value is 0, full length is fetched.
• err_buf: (OUT) Database error buffer

Return Value

• Success
  • SELECT: Returns the number of results in sync mode returns 0 in async mode.
  • INSERT, UPDATE: Returns the number of rows reflected.
  • Others queries: 0
• Failure: Error code

Error Code

• CCI_ER_REQ_HANDLE
• CCI_ER_BIND
• CCI_ER_DBMS
• CCI_ER_COMMUNICATION
• CCI_ER_QUERY_TIMEOUT
• CCI_ER_LOGIN_TIMEOUT