cniSqlExecute
Use this function to run an SQL statement that you have created by using the cniSqlCreateStatement utility function, as defined by the sqlExpression parameter. Use this function when the statement does not return data, for example, when a PASSTHRU function is used.
Syntax
void cniSqlExecute(
int* returnCode,
CciSqlExpression* sqlExpression,
CciMessage* localEnvironment,
CciMessage* exceptionList,
CciMessage* message);
Parameters
returnCode
- The return code from the function (output). Possible return codes are:
- CCI_SUCCESS
- CCI_EXCEPTION
- CCI_INV_INV_SQL_EXPR_OBJECT
- CCI_INV_MESSAGE_OBJECT
sqlExpression
- The SQL expression object to be executed, as returned by the cniSqlCreateStatement utility function (input).
localEnvironment
- The message representing the input local environment (input).
For compatibility with earlier versions, you can refer to this parameter as
destinationList
. exceptionList
- The message representing the input exception list (input).
message
- The message representing the input message (input).
Return values
None. If an error occurs, the returnCode parameter indicates the reason for the error.