HPL queries
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 High-Performance Loader (HPL) 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