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. |