SQL Lookup
Description
Returns results of executing an SQL query.
The SQL Lookup function configuration requires the user to specify a JDBC connection in Hero_Flow, add dynamic values, output fields, and type an SQL query.
Use
- Select an argument. (Any)
- Optional: Select additional arguments. (Any)
- Enter an output field name.
- Select a data type. (Any)
- Select a JDBC connection in Hero_Flow.
- Enter an SQL query string.
- Enter the query timeout value. (Seconds)
- Query statements that are not completed by the timeout value are canceled.
- The value of "0" disables the query timeout feature.
- Click OK.