The High-Performance Loader (HPL) is a
database server tool that you can use to load and unload large quantities
of data efficiently to or from a database.
The HPL lets you exchange data with tapes, data files, and programs,
and converts data from these sources into a format compatible with IBM® Informix® databases.
The HPL also allows you to manipulate and filter the data as you perform
load and unload operations.
The HPL includes the following components:
- The ipload utility, which is a graphical user
interface (GUI). This UNIX application
helps you prepare load and unload jobs for both UNIX and Windows and
includes the following functionality:
- The ipload utility provides a Generate option
that lets you automatically generate the HPL components that are required
for a load or unload job.
- The database-load feature lets you update your databases with
data from any of the supported file types, while allowing you to control
the format and selection of records from the input files. Data can
be loaded from or unloaded to files, tapes, or application pipes (for UNIX), or to any combination of
these three device types.
- The load and unload operations run in the background of your multitasking
operating system. Once the operation begins, you can continue to use ipload to
perform other functions.
- The ipload utility provides context-sensitive
online help. The online help also includes a glossary.
- The onpladm utility, which is a command-line
version of the ipload utility.
- The onpload utility, which allows you to control
HPL from a script.
- The onpload database, which maintains information about load and
unload jobs that you have prepared.
You use the ipload utility to manage the onpload
database on any database server on your network.
Any database server on your network can use the onpload database,
which contains parameters and controls that the HPL uses. This accessibility
allows centralized management of your load and unload controls. These
parameters and controls include the HPL components such as formats,
maps, and projects.
The HPL:
- Supports COBOL, ASCII, multibyte, delimited, or binary data.
- Can load and unload data of a different GLS locale than that of
the database server.
- Provides synonym support for tables that are valid for the local
database server. You can use synonyms for both the load and unload
operations.
- Provides support for unloading data with a query that accesses
a view in its SELECT statement.
- Supports loading of raw tables in express mode.
Release date: March 2013