OVERRIDEDUPS | NOOVERRIDEDUPS
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