Defining the mapping options

This procedure describes how to specify mapping options.

About this task

To define mapping options:

Procedure

  1. Display the Map-Definition window by following the steps for Creating a load map, or Creating an unload map.
  2. Select the field or column (in the right column of a pane) that you want to modify.
  3. Click Options.
    The Mapping Options window appears, as the following figure shows.
    Figure 1: The Mapping Options window

    This window contains define options that onpload applies to the data before it inserts the data into the database (for a load job) or into the data file (for an unload job).
  4. Change the options that you want.
  5. When you have set all the options that you want, click OK to return to the Map-Definition window.

Results

When you return to the map window, an options symbol (a small box) appears between the field and the column, as the following figure shows. The options symbol indicates that mapping options are in effect.
Figure 2: Fragment of the Map-Definition window showing an options symbol

begin figure description - This figure is described in the surrounding text. - end figure description