Valid For
Replicat
Description
Use the UPDATEINSERTS
parameter to convert insert operations to update operations for all MAP
statements that are specified after it in the parameter file. Use NOUPDATEINSERTS
to turn off UPDATEINSERTS
.
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 UPDATEINSERTS
threads in one set of MAP
statements, and specify the NOUPDATEINSERTS
threads in a different set of MAP
statements.
Default
NOUPDATEINSERTS
Syntax
UPDATEINSERTS | NOUPDATEINSERTS
Example
This example shows how you can apply UPDATEINSERTS
and NOUPDATEINSERTS
selectively to different MAP
statements, each of which represents a different thread of a coordinated Replicat.
UPDATEINSERTS MAP sales.cust, TARGET sales.cust, THREAD (1); MAP sales.ord, TARGET sales.ord, THREAD (2); NOUPDATEINSERTS MAP sales.loc, TARGET sales.loc, THREAD (3);