This function allows you to execute an SQL node in phase 3 instead of phase 4. There are several use cases for this.
The function is executed on a separate last field in the SQL node → Each record is executed individually (each iteration).
The function is not executed in a field in the SQL node, but in a field after it → Whole node is executed (all iterations at once).
The SQL node is a stored procedure call and the function is executed on a separate last field in the SQL node → The stored procedure is also committed and the result set is written into a map (name like the SQL node).
The resultset is saved into the map named map_result_<name of SQL node>.
Note: If the data is required in the database during the mapping, the function commit sqlnode in phase3() must be used.
Note: When executing the function, only fields located directly in the specified SQL node are considered, not fields in child nodes.
Parameters
Parameter | Description |
|---|---|
a | Name of the SQL node. |
b | (optional) Comma-separated list of indices defining the positions in the resultset of the called stored procedure which are interpreted as output parameters. The index starts at 1. The output parameters are stored into the map named map_out_<name of SQL node>. |