execute sqlnode in phase3()
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 in the 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 → 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.
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>. |