Execute row SQL script
Description
Execute row SQL script is a step in the Scripting Plugin for Process Studio Workflows. Execute SQL script for every input-row to this step (not). An input field can be used to specify the SQL to execute or it can specify a file that contains the SQL to execute. This step is similar to Execute SQL script but does not have the option to execute SQL during the initialization phase of the workflow
Configurations
| No. | Field Name | Description |
|---|---|---|
| Select & Alter Tab: | ||
| 1 | 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. |
| 2 | Connection | Select a database connection to use |
| 3 | Commit | Specify the number of rows to send before doing a database commit |
| 4 | 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 |
| 5 | 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. |
| 6 | Field to contain insert stats(optional) | Specify a field name to hold the number or records that where inserted. |
| 7 | Field to contain update stats | Specify a field name to hold the number or records that where updated. |
| 8 | Field to contain delete stats | Specify a field name to hold the number or records that where deleted. |
| 9 | Field to contain read stats | Specify a field name to hold the number or records that where read. |