WebSphere Message Brokers
File: as08020_
Writer: Lorraine Waitt

Reference topic

This build: July 31, 2007 21:37:45

cniSqlSelect

Executes an SQL statement that has been 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*        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.

Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:37:45

as08020_ This topic's URL is: