Database join with Process Studio?


How to do a database join with Process Studio?

Madhavi Bade

Hi Madhavi,

To do database join follow the below steps:

The Database Join step allows you to run a query against a database using data obtained from previous steps.

1-Connection: The database connection to use for the query.
2-SQL: SQL query to form the join; use question marks as parameter
3-Number of rows to return: Zero (0) returns all rows; any other number limits the number of rows returned.
4-Outer join: Enable to always return a result, even if the query did not return a result.
5-Parameters table: Specify the fields containing parameters. The parameter type is required.