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
begin figure description - This figure is described in the surrounding text. - end figure description
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

Copyright© 2018 HCL Technologies Limited