Load and unload maps

You can use the ipload utility to build a map. A map specifies the relationship between the fields of a data file and the columns of a database.

To load data into a database, you define a load map, which associates fields from records in a data file to columns in a database table.

To unload data, you define an unload map. The unload map associates the columns that a query retrieves from one or more tables to the fields in a data file.

The following figure shows the relationship between load and unload maps.
Figure 1. Using a map
begin figure description - This figure is described in the surrounding text. - end figure description

The ipload utility stores information about maps in the maps, mapitem, mapoption, and mapreplace tables of the onpload database.

You can define a map at any time. After you define a map, you use it with the Load Job window or the onpload utility.

Copyright© 2018 HCL Technologies Limited