When you choose , you can generate all
of the components required for a load job and an unload job: format,
load map, unload map, query, and device array.
To generate the components for loading or unloading a
database:
- Choose from the main HPL
window to display the Generate window.
- Click Load/Unload Job in the Generate group.
- Select a format for the data file in the Format
Type group.
- Select a name for the generated components and type it
in the Generate Name text box. This
name is used for each of the components that this option creates.
- Type the name of the database that you will load or unload
in the Database text box. Or, click the down
arrow to select a database from the selection list.
- Type the name of the table within the database in the Table text
box. Or, click the down arrow to select a table from the selection
list.
- Type the name of a device array in the Device text
box. Or, click the down arrow to select a device from the selection
list.
If you enter the name of a device (file) instead
of a device array, ipload creates a device array
of the same name as the unload job and inserts the specified device
into that device array.
When you specify a file instead of a
device array in the
Device text box,
ipload makes
the following assumptions about the data file:
- The file is an ASCII file.
- The file uses the same locale as the database.
- The file uses a vertical bar (|) for the field delimiter and a
new line for the record delimiter.
- The fields in the data file are in the same order as the columns
of the target table.
- Click OK.
The following figure shows appropriate choices for generating
load and unload jobs for delimited output from the
state table
of the
stores_demo database. After
ipload creates
the components, you can run the job or use the
Component-Definition windows
to make any necessary changes.
Figure 1. The Generate window
For information about generating a job from a .csv file,
see Testing the import of a CSV file.
