cniSqlSelect

Executes an SQL statement previously created 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*        destinationList,
  CciMessage*        exceptionList,
  CciMessage*        message,
  CciMessage*        outputMessage);

Parameters

returnCode
The return code from the function (output).
sqlExpression
The SQL expression object to be executed, as returned by the cniSqlCreateStatement utility function (input).
destinationList
The message representing the input destination list (input).
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.

Related concepts
User-defined message processing nodes
User-defined output nodes

Related tasks
Creating a message processing node in C

Related reference
C language node utility functions
cniSqlCreateStatement
cniSqlDeleteStatement
cniSqlExecute