cniSqlSelect

Use this function to run an SQL statement that you have created by using the cniSqlCreateStatement utility function, as defined by the sqlExpression parameter. If the statement returns data, the data is written into the message specified by the outputMessage parameter.

Syntax

void cniSqlSelect(
  int*               returnCode,
  CciSqlExpression*  sqlExpression,
  CciMessage*        localEnvironment,
  CciMessage*        exceptionList,
  CciMessage*        message,
  CciMessage*        outputMessage);

Parameters

returnCode

The return code from the function (output).

Possible return codes are:

CCI_SUCCESS
CCI_EXCEPTION
CCI_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).

outputMessage

The message into which any data returned by the statement is written (output).

Return values

None. If an error occurs, the returnCode parameter indicates the reason for the error.