Dynamic SQL Row
Description
Dynamic SQL row is a step in the Lookup Plugin for Process Studio Workflows. The Dynamic SQL row step allows you to execute a SQL statement that is defined in a database field. The lookup values are added as new fields in the output stream
Configurations
| No. | Field Name | Description |
|---|---|---|
| 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 | Specify the field that contains a database connection for the lookup. |
| 3 | SQL field name | Specify the field that contains the SQL to execute. |
| 4 | Number of rows to return Specify the number of records to return. 0 means, return all rows. | |
| 5 | Outer Join | - false: don't return rows where nothing is found - true: at least return one source row, the rest is NULL |
| 6 | Replace variables | In case you want to use variables in the SQL, e.g. ${table_name}, this option needs to be checked. |
| 7 | Query only on parameters change | If your SQL statements do not change a lot, check this option to reduce the number of physical database queries. |
| 8 | Template SQL | In PROCESS STUDIO meta and data are separate so you have to specify the meta part in template SQL (field name and type). I mean any statement that returns the same row structure. |