MAPALLCOLUMNS| NOMAPALLCOLUMNS

Valid For

Valid as a standalone Replicat parameter or as an option to MAP.

Description

An Extract or Replicat checks if all source columns are mapped directly to the target, without using the column mapping function when 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 some MAP 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 of MAPALLCOLUMNS. The MAP specification overrides the global specification for the specified table.

 
NOMAPALLCOLUMNS 
MAP hr.dep, TARGET hr.dep2;
MAP hr.emp, TARGET hr.emp2, MAPALLCOLUMNS ;