MAPALLCOLUMNS| NOMAPALLCOLUMNS
Valid For
Valid as a standalone Replicat parameter or as an option to MAP
.
Description
MAPALLCOLUMNS
parameter is specified. If any source column is
not mapped, then the Extract or Replicat abends.
Note:
This parameter is mainly used when performing heavy transformation using the Replicat, and you must ensure that all the data is available for transformation.MAPALLCOLUMNS
and NOMAPALLCOLUMNS
can be used in two different ways. When specified at a global level, one parameter remains in effect for all subsequent MAP statements, until the other parameter is specified. When used within a MAP
statement, they override the global specifications.
Default
NOMAPALLCOLUMNS
Syntax
MAPALLCOLUMNS | NOMAPALLCOLUMNS
Examples
- Example 1
-
This example enables
MAPALLCOLUMNS
for someMAP
statements while disabling it for others.MAPALLCOLUMNS MAP hr.emp, TARGET hr.emp2; NOMAPALLCOLUMNS MAP hr.dep, TARGET hr.dep2;
- Example 2
-
This example shows a combination of global and
MAP
-level use ofMAPALLCOLUMNS
. TheMAP
specification overrides the global specification for the specified table.NOMAPALLCOLUMNS MAP hr.dep, TARGET hr.dep2; MAP hr.emp, TARGET hr.emp2, MAPALLCOLUMNS ;