...
This activity runs a query on an Oracle a DB2 Server database.
Activity Parameters
The Run Query activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Query (text box editor type) (type: string): the SQL query string. For example: "SELECT Name, Company FROM FLOWSTERNAMESs NAMES where ID>1 and ID<4 order by name ASC"
The Read Only Output variable are the possible output values that the activity will provide:
...
Execution: In the Tracking Data there can be seen the returned results:
The same result can be seen when executing the same SQL Select query from Oracle Application ExpressDB2 (IBM Data Studio was used for the examples):
Select Row(s) from Table
...