Generating Load and Unload Components

When you choose Components > Generate, 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 an Informix database

Choose Components > Generate Job from the main HPL window.
The Generate window appears, as Figure 115 shows.
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.

Figure 116 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.