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. Refer to KB3522595
for details.
| 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. |