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.