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

Creating an Unload Map

Before you can create an unload map, you must define a query on the table that will be unloaded. For instructions on how to define a query, see Queries.

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. An Ext Type column can be mapped only to an Ext Type field. 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 an unload map
  1. Choose Components > Maps > Unload Map from the HPL main window.

    The Unload Record Maps window appears, as Figure 89 shows.

    Figure 89. The Unload 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 the name in the Map Name text box.
  4. Type the name of the database in the Database text box.

    You can click the down arrow to choose a database from a selection list of databases.

  5. Type the name of a query in the Query text box.

    You can click the down arrow to choose a query from a selection list of queries.

  6. Type the format name in the Format text box.

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

  7. Click OK.

    A map-definition window similar to Figure 90 appears. In this figure, some of the field names match column names. The ipload utility automatically maps columns to fields of the same name. The direction of the arrows indicates the flow of data, as shown in Figure 90.

    Figure 90. The Map-Definition Window
    begin figure description - This graphic depicts the ipload graphical user interface. The onpladm command line utility provides the same functionality. - end figure description
  8. To map a database column to a data-file field, click the database-column icon. Drag the column to the desired data-file field icon.

    An arrow links the column icon to the field icon.

  9. Repeat step 8 until you have mapped all desired columns to fields.
  10. Define any mapping options as appropriate.

    For information about mapping options, see Mapping Options.

  11. Click OK to save the map and return to the Unload Record Maps window.
  12. Click Cancel to return to the HPL main window.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]