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;