Data Compare Column Mapping Screen

Column mapping in the Data Compare facility works the same way as in the RC/Copy facility.
carcudb2
Column mapping in the Data Compare facility works the same way as in the RC/Copy facility.
Note:
For information about the fields, press F1 (Help).
Mapping Manually
To map the columns manually, enter the source column number in the Map # field of the target column.
Mapping Automatically
Two commands, AUTOMAP and RESET, are provided to help map the source columns to the target columns. Type a mapping command at the command line and press Enter.
Enter
AUTOMAP
to perform default column mapping. This can save time when only a few of the column mappings need to be changed. Data Compare makes default mappings based on name, type, and length (in that order). For a different order of precedence, use the N, T, and L parameters after the AUTOMAP command. The default is NTL. Specify any combination of these codes to control auto-mapping.
  • N
    Specifies to AUTOMAP only if the column names are equal.
  • T
    Specifies to AUTOMAP only if the column types are equal.
  • L
    Specifies to AUTOMAP only if the column lengths are equal.
AUTOMAP can be abbreviated as AM.
Enter
RESET
to clear the current column mapping so the process can be restarted. Use this command with automapping to experiment with different mapping techniques. The command can be abbreviated as RES.
To begin automapping, enter the command and press Enter.
To cancel processing, enter the CANCEL command or press the appropriate function key.
To Exit the Data Compare Column Mapping Screen, press the F3 (End) key to return to the Data Compare Explode Services panel. The MAP column updates to YES for the mapped tables.