Overview
Description - The SQL Query Action executes SQL queries against relational databases.
Database Connection Type - Specifies the type of connection to be used to connect to the database.
...
Result Set Type - Specifies the type of result set to use when returnin the query results. The options are:
- *Live Result* - The query results are fetched from the dabase server on an as needed basis using a data set cursor. This is the preferred option when the data sets being returned are expected to be very large. Performance is slower but memory usage is reduced.
- In-Memory Result Set - The query results are returned in their entirety from the database server and cached on the BI server.
...
- Immediately - The query is run immediately by the Pentaho BI server.
- From Pentaho Subreport - The query is prepared for execution, with the intention of being run later in the action sequence by a subreport within a JFree Report. See the JFree Report action for further details.
Result Set Columns - The names of each of the columns in the resulting data set. The names must be entered in the order in which they will appear in the data set. The column names need to be provide only if a column will be referenced by name within the action sequence.
Result Set Name - The name of the resultting output dataset. Following actions can refer to the data set using this name.