You can build an SQL statement with the ipload query
component.
The ipload utility stores query information
in the query table of the onpload database. The SQL statement
is stored as TEXT data.
During the unload process, the uses
a query to select data from a database table (or tables), as the following
figure shows. The HPL can process any valid SQL statement. Figure 1: Extracting data from
a database table
These topics use the term query in two ways:
To refer to the SQL statement that selects information from the
database
To refer to the HPL component that lets you build and store the
SQL statement