New Column Map Dialog

When you choose to create a new Column Map from the Definitions submenu, the Column Map Editor opens, along with the New Column Map dialog. You can also open the New Column Map dialog by selecting New from the File menu in the Column Map Editor.

(For a description of the Definitions submenu, see From the Main Window: Move or Archive.)

After you specify the appropriate parameters in the New Column Map dialog, the Column Map Editor is displayed.
new column map panel where you specify source and destination details

Server Name

If the optional Optim™ Server is installed on your network, and the table containing the source column is in an Extract or Archive File, click the down arrow to select Local if the file is accessed from the client workstation, or the Server on which the file resides.

Validation Rules

If the Column Map is to be used in a Convert, Insert, or Restore Process, select Move/Archive validation rules. Select Compare for use in a Compare Process. The group box labels vary according to your selection. In the previous illustration, Move/Archive validation rules are selected and the group boxes are labeled Source and Destination. For Compare validation rules, the labels are Source 1 and Source 2.

Source or Source 1

When you create a new Column Map, you must indicate the source for the columns you want to map. You can specify the source as a table in an Extract or Archive File or the database:

File
Select this option to map columns from a table in an Extract or Archive File.
Name
Directory path and name of the file. If a directory path is not specified, the data directory path specified in Personal Options is used by default.
  • To select from a list of recently used file names, click the down arrow.
  • To select from another directory, click the browse button.
Table
Name of the table in the file. To select from a list, click the down arrow.
Database Table
Select this option to map columns in a table that resides in the database.
Name
Fully qualified name of the database table.
  • To select from a list of recently used table names, click the down arrow.
  • To select from a directory of existing tables, click the browse button.

Destination or Source 2

For Move/Archive validation rules, the destination can only be Database Table. For Compare validation rules, all Source 2 options apply.

File
Select this option to map columns from a table in an Extract or Archive File. This option is enabled if Compare validation rules are selected.
Database Table
Fully qualified name of the destination table that is mapped to the source table.
Use Column Attributes from Source Table if Table does not exist
Select this check box to use column attributes from the source table to map columns for the destination table. Use this when defining a Column Map as part of a request and the destination table does not exist. This check box is enabled if Move/Archive validation rules are selected.

Enter the appropriate parameters, provide entries to define the source and destination tables OR Source 1 and Source 2 tables, and select OK to open the Column Map Editor.