Valid For
Replicat
Description
Use the UPDATEDELETES
parameter to convert delete operations to update operations for all MAP
statements that are specified after it in the parameter file. Use NOUPDATEDELETES
to turn off UPDATEDELETES
. These parameters are table-specific. One remains in effect for subsequent MAP
statements until the other is encountered.
Because you can selectively enable or disable these parameters between MAP
statements, you can enable or disable them for different threads of a coordinated Replicat. Specify the UPDATEDELETES
threads in one set of MAP
statements, and specify the NOUPDATEDELETES
threads in a different set of MAP
statements.
When using UPDATEDELETES
, use the NOCOMPRESSDELETES
parameter. This parameter causes Extract to write all of the columns to the trail, so that they are available for updates.
Default
NOUPDATEDELETES
Syntax
UPDATEDELETES | NOUPDATEDELETES
Example
This example shows how you can apply UPDATEDELETES
and NOUPDATEDELETES
selectively to different MAP
statements, each of which represents a different thread of a coordinated Replicat.
UPDATEDELETES MAP sales.cust, TARGET sales.cust, THREAD (1); MAP sales.ord, TARGET sales.ord, THREAD (2); NOUPDATEDELETES MAP sales.loc, TARGET sales.loc, THREAD (3);