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;