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 HPL 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 about 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:

Choose Components > Maps > Unload Map from the HPL main window.
The Unload Record Maps window appears, as the following figure shows.
Figure 1. The Unload Record Maps window
Click Create in the Selection Type group.
Choose a name for the map and type the name in the Map Name text box.
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.
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.
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.
Click OK.
A Map-Definition window is similar to the following figure. 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.
Figure 2. The Map-Definition window
To map a database column to a data-file field, click the database-column icon. Drag the column to the data-file field icon that you want. An arrow links the column icon to the field icon.
Repeat step 8 until you have mapped all the columns you want to fields.
Define any mapping options as appropriate. For information about mapping options, see Mapping options.
Click OK to save the map and return to the Unload Record Maps window.
Click Cancel to return to the HPL main window.