Column Map Editor

After you identify the tables on the Specify Column Map Tables panel and press Enter, the Column Map editor is displayed, listing the Destination or Source 2 columns and data types with any matching source columns. The Column Map editor is also displayed from the Table Map editor or from the Specify COMPARE Sources panel, when you enter the name of a new Column Map or use the MAP command.

The Column Map editor is labelled as the Define Column Map panel when you provide the name of a new Column Map, and the Modify Column Map panel when displayed from the Table Map editor or you enter the name of an existing Column Map. In the initial display for a new Column Map, destination columns are automatically paired with any source columns with compatible data types that have the same name. Source 1 and Source 2 columns are paired automatically if both name and attributes (data type and precision) match exactly.

Figure: Define Column Map - Initial Column List

-- Define Column Map: ARC1997.ORDERS ------------------------------------------
Command ===>                                                  Scroll ===> PAGE 

Corresponding Columns MUST Have Compatible Data Types     
Use LIST UNUSED Command for List of Unused Source Columns 
Use LIST ALL Command for List of All Source Columns                     VAL ON 
                                                                        MOVE   
                                                                        1 OF 8 
    --------FOPDEMO.ORDERS----------  -------------RESTORED.ORDERS-------------
Cmd     Source Column     Data Type   Num Destination Column Data Type  Status 
--- ------------------->> ----------  --- ------------------ ---------- -------
*** *********************************** TOP ***********************************
___ ORD_ID                CH(5)         1 ORD_ID             CH(5)      EQUAL  
___                                     2 CUST_ID            CH(5)      NOTUSED
___                                     3 ORDER_DATE         DATE       NOTUSED
___                                     4 ORDER_TIME         TIME       NOTUSED
___                                     5 FREIGHT_CHARGES    DEC(4,2)   NOTUSED
___ ORDER_SALESMAN        CH(6)         6 ORDER_SALESMAN     CH(6)      EQUAL  
___                                     7 ORDER_POSTED_DATE  TIMESTAMP  NOTUSED
___ ORDER_SHIP_DATE       CH(8)         8 ORDER_SHIP_DATE    CH(8)      EQUAL  
*** ********************************* BOTTOM **********************************

The Column Map editor includes:

Cmd
The line command area. Valid line commands on the Define/Modify Column Map panel are:
CLR
Clear Source or Source 1 Column entry.
D
Delete entries with UNKNOWN status.
EXP
Display Source or Source 1 Column entry in a pop-up window to specify a column value or column map expression.
I
Display status information about a source and destination pairing. Useful for *ERROR* status.
LUA
Displays an ISPF edit panel for specifying Lua scripting language statements.
SRC
Replace Source or Source 1 Column entry with name of Source Column.
AGE
Display AGE function prompts (Move only).

Source or Source 1

The fully qualified name of the Source or Source 1 table is displayed before the headings:

Column
The value that is mapped to the Destination or Source 2 Column listed on the same line. For a Compare Process, specify a source column name or blanks. For processes other than Compare, you can also enter a literal, an expression, a column map procedure, a function, an exit routine, a special register, or NULL. Valid entries vary according to the destination Data Type.
Note: If you eliminate a foreign key column from a Compare Process by eliminating the Source 1 value, the relationship cannot be used to determine whether related changes have occurred. Also, to use a Match Key in a Compare Process, all Match Key columns must be processed. If you omit a primary key column from the Compare Process, you are prompted to specify a Match Key from columns in the Column Map.
Data Type
The data type for the source. Generally, Data Type is blank if the Source Column value is not the name of a column in the current source table. When the Source Column entry is an AGE function specification, however, the data type is either blank or PROP (if the aged value is to be propagated).

The data types for source and destination must be compatible. See Compatibility Rules for more information.

The data type is automatically supplied and cannot be modified. Generally, the DB2 or Legacy data type is displayed; however, due to space limitations, the following data types are abbreviated. Data types are shown, followed by the abbreviations:

CHAR CHAR FOR MIXED DATA
CH
VARCHAR
VCH
LONG VARCHAR
LVR
DECIMAL
DEC
FLOAT 4-byte length
SNGL FLOAT
FLOAT 8-byte length
DBL FLOAT
BLOB
BL
CLOB
CL
CLOB FOR MIXED DATA
CLOB
GRAPHIC
GR
VARGRAPHICLONG VARGRAPHIC
VGR
BINARY
BIN
VARBINARY
VARBIN

Destination or Source 2

The fully qualified name of the Destination or Source 2 table is displayed before the headings:

Num
A sequential number assigned, in ascending order, to each Destination or Source 2 column. Use these values with source column selection lists or the EXPAND command.

Num is populated for columns in the current destination table only.

Column
The read-only names of the Destination or Source 2 columns listed in the order defined in the table.
Data Type
The data type for the Destination or Source 2 column. Data Type is blank if the column is not in the current destination or source table. Due to space limitations, some data types are abbreviated. For more information, see the Source or Source 1 Data Type description.
Status
The status of each column pairing. The matched pairs are assigned the status EQUAL or MAPPED. Any pair that does not match is assigned NOTUSED or REQUIRD status.
EQUAL
The columns have the same name, data type, and length.
*ERROR*
The specified mapping is invalid. A Column Map cannot be saved with columns in *ERROR* status. Use the I line command to determine the reason for the error.
EXIT
The source column value is determined by a site-provided exit routine.
EXPR
The source column value is an expression or a function.
LITERAL
The source column value is a literal.
Lua
The source column value is a column map expression or column map procedure using the Lua scripting language.
MAPPED
The columns do not have identical data types or length but are compatible. This status also applies to mapped columns that are not validated.
NOT_INS
A value cannot be inserted into the column. For example, the column may be an expression in a view.
NOTUSED
No source entry is specified. For load or insert processing, the default value for the destination column is inserted. For update processing, the value in the destination column is not updated. The column does not participate in a Compare Process.
NULL
The source column value is NULL.
REQUIRD
No source column value is provided and the destination column is defined as NOT NULL (with no default column value). For update processing, the value in the destination column is not updated. For insert processing, a value is required.
When you save a Column Map with columns in REQUIRD status, a confirmation prompt reminds you that the Column Map can be used only to update rows. Press Enter to save the Column Map or use END to return to the editor from this pop-up.
Note:
  • You cannot use a Column Map with columns in REQUIRD status for insert or load processing.
  • You cannot use a Column Map with a primary key column in REQUIRD.
SPC_REG
The source column value is a special register.
TRANSFM
The source column value is a data privacy transformation library function.
UNKNOWN
The column does not exist in the current Destination or Source 2 table. This status may occur if the column is dropped from the destination table after the map is created or if the destination table specification is changed.

Use the D line command or the DELETE UNKNOWN primary command to delete entries in UNKNOWN status and adjust the column count.

Available Commands

The following primary commands are available:

Column Map Description

Use the ATTRIBUTES command to display the Object Attributes panel, which allows you to specify a description for the Column Map. This panel provides a 40-character area to display and edit the description. (Site management determines whether this panel also displays a prompt for Security Status.) For additional information about the Object Attributes panel, see Specify Description and Security Status.

SAVE

After editing a Column Map, you can save it under a different name, using the SAVE command with the fully qualified name as an operand. If you invoked the Column Map editor from the Table Map editor or the Specify Compare Sources panel, you can also use SAVE LOCAL to save the Column Map as part of the Table Map or Compare Definition.

Parent topic: Column Maps