Column Maps

This syntax is used to generate a statement for each exported Column Map.

CREATE CM identifier.name 
   [DESC //description//] [EXTDSN extractfilename] 
   SRC srctable DEST destable  VALRULES {M | C}
   (src-expr = dest-col 
   [,src-expr = dest-col]); 

Keywords

The keywords correspond to values that can be specified for a Column Map. For information about an individual parameter, see Using the Editor.

CM
Specify the name of the Column Map.
identifier.name
The two-part name of the Column Map.
DESC
Describe the content or purpose of the Column Map.
//description//
The 1 to 40 character description of the Column Map, delimited by double slashes.
EXTDSN
Enter the name of the Extract or Archive File from which column definitions are taken.
extractfilename
The name of the Extract or Archive File containing the Source table defined in the Column Map.
SRC
Specify the fully-qualified name of the source table, containing the columns defined in the Column Map.
dbalias.cid.tablename
Fully qualified name of the source table.
DEST
Specify the fully-qualified name of the destination table.
dbalias.cid.tablename
Fully qualified name of the destination table.
VALRULES
Indicate the validation rules for the Column Map.
M
Move/ARchive for Column Maps for Convert, Extract, Insert, or Load Requests.
C
Compare for Column Maps.

The following source column to destination column mapping information is required for each column in the Column Map. At least one pair of columns must be specified.

src-expr
Text of the expression specified for the source column (Source Column).
dest-col
The name of the destination column (Destination Column).

One of the following is included when a Column Map Procedure is specified for a pair of columns.

CMPROC
The name of the Column Map Procedure for the pair of columns.
LOCAL CMPROC
The local Column Map Procedure definition enclosed in parentheses.