Creating an unload map
Before you begin
About this task
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:
Procedure
-
Choose
from the HPL main window.The Unload Record Maps window appears, as the following figure shows.
- 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.
-
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.