The setting for Rules used to validate Column Map on the Choose a Column Map panel determines the format of the selection list and the rules applied to a selected Column Map. If you select Archive and Move rules, the selection list identifies the source and destination tables and Archive and Move rules apply to the selected Column Map. If you select Compare rules, the selection list identifies the Source 1 and Source 2 tables and Compare rules apply to the selected Column Map.
An example of a Column Map Selection List when Archive and Move rules are selected is shown in the following figure.
Figure: Select Column Maps
--------------------------- Select Column Maps --------------------------------
Command ===> Scroll ===> PAGE
Line Cmds: S-Select, D-Delete, C-Copy, R-Rename, AR-Attr, I-Info 1 of 8
-------- Map -------- -------- Source --------- ------ Destination ------
Cmd ID Name Creator Table Creator Table
--- -------- ---------––- ------>> -------------->> ------>> -------------->>
******************************* TOP ************************************
___ ARC1997 ORDERS FOPDEMO ORDERS RESTORED ORDERS
___ ARC1997 FOPCUST FOPDEMO CUSTOMERS RESTORED CUSTOMERS
___ ARCHIVE TEST OPTIM SHIP_TO RESTORED SHIP_TO
___ ARCHIVE TEST2 OPTIM CUSTOMERS FOPDEMO CUSTOMERS
Column Maps that match the criteria are listed. The Map ID and Name are displayed, as well as Creator ID and Table Name for source and destination tables.
A User Option determines whether the description of each Column Map is displayed on this panel. See User Options for information about the Selection List Format option.
The Cmd area of the panel is used to enter line commands. The following line commands are available:
Use the S line command or the SELECT primary command to select a Column Map to display in the Modify Column Map panel. If the source table or file for the Column Map does not exist, the Specify Column Map Tables panel is displayed, prompting for source and destination table names. After you provide the table names, the Define Column Map panel is displayed, allowing you to define a Column Map. (The Modify Column Map panel is the same as the Define Column Map panel, and is described in Column Map Editor.)
You can also use the SELECT primary command to display a Column Map that is not included on the selection list. For example, to select the Column Map named FOPDEMO.TESTMAP, enter:
SELECT FOPDEMO.TESTMAP
If the Column Map named on the SELECT primary command does not exist, the Specify Column Map Tables panel is displayed to allow you to create a new Column Map.
To display the attributes of a Column Map, type I in Cmd next to the name of the Column Map. The following figure shows the read-only Column Map Attributes panel for an Archive or Move Column Map, which includes Source Table and Destination Table. Compare Column Maps will include Source 1 Table and Source 2 Table information.
Figure: Column Map Attributes
----------------------------- Column Map Attributes --------------------------- Command ===> ID : ARC1997 Name : ORDERS Description : Security Status : PRIVATE Last Modified By : FOPDEMO Modified On : 2010-08-02 10.36.05 Number of Columns : 8 Destination Table : RESTORED.ORDERS Source Type : FILE Extract File Name : FOPDEMO.ARCHIVE.FILE Source Table : FOPDEMO.ORDERS Validations : YES
This is a read-only display. Optim generates and maintains the information on this panel based on your specifications for the Column Map. Number of Columns is the number of columns in the destination table, while Source Type indicates whether the source is a database table (TABLE), a table in an Extract or Archive File (FILE) or no table was provided (NONE). Note that Extract File Name is blank unless Source Type is FILE. Validations indicates whether the Column Map was validated when created.