Execute row SQL script
Options
| Option | Description |
|---|---|
Transform name | Name of the transform; This name has to be unique in a single pipeline |
Connection | Select a database connection to use |
Commit | 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. (Available since 5.0) |
Field to contain insert stats | Optional: If you want to get an additional field in our stream with the number or records that where inserted, please define the field name here. |
Field to contain update stats | Same as insert stats, but for updated rows. |
Field to contain delete stats | Same as insert stats, but for deleted rows. |
Field to contain read stats | Same as insert stats, but for read rows. |