This function executes an SQL node in Phase 3 instead of Phase 4. There are several use cases for this.
Last, separate field in the SQL node: The function executes each record individually (each iteration).
Field after the SQL node: The function executes the entire node (all iterations at once).
Stored procedure call in the last, separate field: The function commits the stored procedure immediately. It writes the result set into a map. The map name matches the name of the SQL node.
The function saves the result set in the map named
map_result_<name of SQL node>.
NOTE: The database sometimes needs the data already during Mapping. In this case, use the function commit sqlnode in phase3().
NOTE: The function only considers fields located directly in the specified SQL node when executing. It ignores fields in child nodes.
Parameters
Parameter | Description |
|---|---|
| Name of the SQL node. |
| (optional) Comma-separated list of indices. The indices define positions in the result set of the called stored procedure. These positions provide the output parameters. The index starts at The function stores the output parameters in the map named |