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