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;