Execute row SQL script
Description
Execute Row SQL Script runs a SQL statement for every incoming row, using either a field value or a file reference to specify the SQL to execute. Use this step when you need to perform row-level database operations with dynamic SQL — for example, running different update statements based on each row's data or executing custom queries constructed by a previous step. Unlike Execute SQL Script, this step does not support initialization-phase execution and is focused entirely on per-row processing.
Configurations
| Field Name | Description |
|---|---|
| Select & Alter Tab: | |
| Step name | Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| Connection | Select a database connection to use |
| Commit | Specify the number of rows to send before doing a database commit |
| SQL field name | The field that either contains the SQL to execute or optionally specifies the path to a file that contains SQL to execute |
| Read SQL from file | If checked, then the SQL field name option specifies a file that contains SQL to execute, otherwise the SQL field name option specifies the actual SQL to execute. |
| Field to contain insert stats(optional) | Specify a field name to hold the number or records that where inserted. |
| Field to contain update stats | Specify a field name to hold the number or records that where updated. |
| Field to contain delete stats | Specify a field name to hold the number or records that where deleted. |
| Field to contain read stats | Specify a field name to hold the number or records that where read. |