Defines a specific retrieval operation or a list of retrieval operations.
<PARAM NAME = "retrievals" VALUE = "retrievalName">
The retrievals PARAM tag defines a single operation or a list of several retrieval operations. This tag is then immediately followed by another tag (or tags) that specify each previously defined retrieval operation as the NAME attribute followed by an SQL String, a parameterized SQL string, or a saved query file as the VALUE attribute.
A parameterized SQL string contains '%' as the delimeter and a save query file to read in is specified using '@' as the first character of the query text value.
In the following example three retrieval queries are defined by the retrievals PARAM tag:
This tag is immediately followed by three other PARAM tags that specify each previously defined retrieval operation (in each consecutive NAME attribute) followed by the following query statements in the VALUE attribute: an SQL String, a parameterized SQL string, and a saved query file.
<PARAM NAME="retrievals" VALUE="EmpInfo, SalesForRegionYear, EmpInfoSaved">
<PARAM NAME="EmpInfo" VALUE="select * from employee">
<PARAM NAME="SalesForRegionYear" VALUE="select sum(sales) from salesinfo where region='%region%' and year=%year%">
<PARAM NAME="EmpInfoSaved" VALUE="@x.qry">
You can then follow these PARAM tags with the _resultStyle PARAM tag to define the format of the query result data.
Example
retrievals PARAM tag example
See also
JdbcSource applet
_resultStyle PARAM tag
Executing a database query