APPLYNOOPUPDATES | NOAPPLYNOOPUPDATES
Valid For
Replicat
Description
Use APPLYNOOPUPDATES
to force a no-op UPDATE
operation to be applied by using all of the columns in the SET
and WHERE
clauses. See ALLOWNOOPUPDATES | NOALLOWNOOPUPDATES for a description of no-op.
APPLYNOOPUPDATES
causes Replicat to use whatever data is in the trail. If there is a primary-key UPDATE
record, Replicat uses the before columns from the source. If there is a regular (non-key) UPDATE
, Replicat assumes that the after value is the same as the before value (otherwise it would be a primary-key update). The preceding assumes source and target keys are identical. If they are not, you must use a KEYCOLS
clause in the TABLE
statement on the source.
Default
NOAPPLYNOOPUPDATES
Syntax
APPLYNOOPUPDATES | NOAPPLYNOPUPDATES