Valid for
Replicat
Description
Use OVERRIDEDUPS to direct Replicat to always apply the record it is currently processing. When NOOVERRIDEDUPS is in effect, a duplicate error is returned and the transaction may abort.
Duplicate errors can be caused when multiple sources insert the same record into a single target. If both of these operations are replicated to the same target, one will fail because each has the same primary key.
NOOVERRIDEDUPS remains in effect until OVERRIDEDUPS is specified. OVERRIDEDUPS remains in effect for all maps specified below it until NOOVERRIDEDUPS is entered.
Records may not be processed in chronological order across Replicat processes. To bypass duplicate records without causing Replicat to terminate abnormally, specify either of the following REPERROR parameters. Even so, when duplicate errors occur, records are output to the discard file.
REPERROR (10, IGNORE) REPERROR (-8227, IGNORE)
OVERRIDEDUPS is automatically in effect when HANDLECOLLISIONS is specified.
Default
NOOVERRIDEDUPS
Syntax
OVERRIDEDUPS | NOOVERRIDEDUPS