UPDATEDELETES | NOUPDATEDELETES
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. The UPDATE WHERE
clause uses the same key columns that
the DELETE
statement was going to use. So this works best on tables
that have a primary key or unique key.
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);