2.188 REPNEWCOLUMNS | NOREPNEWCOLUMNS

Valid for

Replicat

Description

Use REPNEWCOLUMNS to tell Replicat to deliver SQL ALTER TABLE ADD COLUMN statements from the source database to the target database. REPNEWCOLUMNS can be applied on a table-by-table basis.

Default

NOREPNEWCOLUMNS

Syntax

REPNEWCOLUMNS | NOREPNEWCOLUMNS

Example

The following example delivers new columns to TABLE1, TABLE2 and TABLE4, but not TABLE3.

REPNEWCOLUMNS
MAP \LA.$DATA1.DAT.TABLE1, TARGET \NY.$DATA1.DAT.TABLE1;
MAP \LA.$DATA1.DAT.TABLE2, TARGET \NY.$DATA1.DAT.TABLE2;
NOREPNEWCOLUMNS
MAP \LA.$DATA1.DAT.TABLE3, TARGET \NY.$DATA1.DAT.TABLE3;
REPNEWCOLUMNS
MAP \LA.$DATA1.DAT.TABLE4, TARGET \NY.$DATA1.DAT.TABLE4;