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