SQLDUPERR

Valid For

Replicat

Description

Use the SQLDUPERR parameter to specify the numeric error code returned by the target database when a duplicate row is encountered. A duplicate-record error indicates that an INSERT operation was attempted with a primary key that matches the key of an existing record in the database.

You must use SQLDUPERR when you specify the special handling of duplicate records with the OVERRIDEDUPS parameter. See "OVERRIDEDUPS | NOOVERRIDEDUPS" for more information.

Default

None

Syntax

SQLDUPERR error_number

error_number

The numeric error code to return for duplicate records.

Example

SQLDUPERR -2601