Output variables available to all SQL Query nodes

This section describes the output variables that are available with the SQL Query node.

Variable Description
NODENAME_errorCode The error code for this activity. The error code will be 0 if successful, non-zero for error.

NODENAME_informationCode or

NODENAME_RETURN_CODE

The return code (where 0=Success and 1=Failure) returned by a query.

NODENAME_returnMessage or

NODENAME_RETURN_MSG

The message returned by a query.
NODENAME_RECORD_COUNT (Integer) The number of records that were counted in a query.
NODENAME_<COLUMN_NUM> The Return data can be referenced by column number, row number, and column name.
NODENAME_<ROWNUM> _<COLNUM> The Return data can be referenced by column number, row number, and column name.
NODENAME_<COLUMN_NAME> The Return data can be referenced by column number, row number, and column name.
NODENAME_<COLUMN_NAME>_<ROWNUM> The Return data can be referenced by column number, row number, and column name.