Database Join
Description
Database join is a step in the Lookup Plugin for Process Studio Workflows. The Database Join step runs a query against a database using data obtained from previous steps. The parameters for this query are specified as follows:
-
The data grid in the step properties dialog. This allows you to select the data coming in from the source hop.
-
As question marks (?) in the SQL query. When the step runs, these will be replaced with data coming in from the fields defined from the data grid. The question marks will be replaced in the same order as defined in the data grid.
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 database connection to use for the query. |
| 3 | SQL | Specify the SQL query to form the join between source parameters and the database connection specified; use question marks as parameter placeholders |
| 4 | Number of rows to return | Specify the field name to store Number of rows to return. Zero (0) returns all rows; any other number limits the number of rows returned. |
| 5 | Outer join? | Enable to always return a result, even if the query did not return a result |
| 6 | Parameters table | Specify the fields containing parameters. Also specify the data type is required. |