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.

Type

Lookup