Dynamic SQL Row
Description
Dynamic SQL Row executes a SQL statement that is provided in an input field, rather than being hardcoded in the step configuration. Use this step when the SQL query itself varies per row — for example, when a previous step constructs different SELECT statements based on business logic or when queries are stored in a configuration table. The query results are appended as new fields to the output stream, making this step useful for flexible, data-driven database lookups.
Configurations
| Field Name | Description |
|---|---|
| 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 | Specify the field that contains a database connection for the lookup. |
| SQL field name | Specify the field that contains the SQL to execute. |
| Number of rows to return | Specify the number of records to return. 0 means, return all rows. |
| Outer Join | - false: don't return rows where nothing is found - true: at least return one source row, the rest is NULL |
| Replace variables | In case you want to use variables in the SQL, e.g. ${table_name}, this option needs to be checked. |
| 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. |
| 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. |