Performs a SQL query against a JDBC or JNDI data source. The query results are available as an output to the action. The query may contain references parameters be enclosing the parameter in curly braces. For example select * from myTable where department = '{dept}' would replace {dept} with the value of the parameter named "dept".
Component Name:
...
Relational
Inputs:
REQUIRED
JNDI Name - Name of the JNDI connection.
...
Note: Any parameter may be referenced in the query by enclosing the parameter in curly braces.
Outputs:
Result Set Name-- The name of the parameter in which to store the query results.
...