Output variables available to all SQL Query nodes
This section describes the output variables that are available with the SQL Query node.
Note: Starting with the 2024.10 release, the SQL Query activity node will be deprecated and removed from the Infor Process Designer (IPD) tool, Infor Process Designer for the Web (IPD Web), and runtime server. Additionally, this node is no longer supported in multi-tenant environments and will be removed on a later date. See KB3522595.
| 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. |