Column Mapping

There might be the need to map columns from the source table to columns in a target table that differ in name, type, or length. The RC/Copy Column Mapping feature permits mapping of source columns to target columns. All data conversions are automatically performed. For example, a column defined as CHAR can be copied to VCHAR.
carcudb2
There might be the need to map columns from the source table to columns in a target table that differ in name, type, or length. The RC/Copy Column Mapping feature permits mapping of source columns to target columns. All data conversions are automatically performed. For example, a column defined as CHAR can be copied to VCHAR.
There also may be a need to omit a column from the copy operation, so DB2 can generate a value for the target column. This is necessary if the column is GENERATED ALWAYS (and appears as A or I in the DF column). It is optional if the column is GENERATED BY DEFAULT (and appears as D or J in the DF column). A GENERATED column is either a ROWID column (indicated by values A and D in the DF column) or an identity column (indicated by values I and J in the DF column). You omit a column by setting its MAP# to blank, instead of specifying a numeric value.
The RC/Copy Column Mapping screen has two independent scrolling areas.
For information about the fields, press F1 (Help).
When you leave the MAP# blank, DB2 supplies the values.