Home | Previous Page | Next Page   Defining Maps > Load and Unload Maps >

Creating a Load Map

You can create a load map from the Load Job window or from the Components menu of the HPL main window. Before you can create a load map, you must create a format that describes the data file that you plan to load. For information about how to create a format, see Defining Formats.

Important:
The HPL does not support conversion from extended type data and smart-large-object data (Ext Type data types) to non-Ext Type data types. A field that is defined as an Ext Type data type can be mapped only to an Ext Type column. For more information on Ext Type data types, see Data Types Allowed in a Fixed Format or Data Types Allowed in a Delimited Format.
To create a load map
  1. Choose Components > Maps > Load Map from the HPL main window.

    The Record Maps window appears, as Figure 87 shows.

    Figure 87. The Load Record Maps Window
    begin figure description - This graphic depicts the ipload graphical user interface. The onpladm command line utility provides the same functionality. - end figure description
  2. Click Create in the Selection Type group.
  3. Choose a name for the map and type it in the Map Name text box.
  4. Type the names of the database and table where the data will be loaded in their corresponding text boxes.

    You can also click the down arrow to choose the names from a selection list. The Tables selection list includes synonyms that are valid for the local database server.

  5. Type the format that describes the data file in the Format text box.

    You can also click the down arrow to choose the format from a selection list.

  6. Click OK to open the map-definition window.

    A map-definition window similar to Figure 88 appears.

  7. Click a column icon in the left-hand column in the Table pane and hold the mouse button down. A box appears around the icon and its name.
  8. Drag the box to a field icon in the Format pane.

    When you connect columns to fields, it does not matter whether you drag a column to a field or drag a field to a column, but you must always connect items from the left-hand column of each pane.

    Figure 88 shows a map-definition window with this step completed.

    Figure 88. Map-Definition Window, One Association Completed
    begin figure description - This graphic depicts the ipload graphical user interface. The onpladm command line utility provides the same functionality. - end figure description
  9. Repeat steps 7 and 8 for each field that you want to transfer into the database.
  10. Add desired options, if any.

    For instructions, see Using Mapping Options.

  11. Click OK to return to the Load Record Maps window.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]