Master Mainframe Technologies - COBOL, JCL, DB2, VSAM, CICS & More
ABEND Codes SQLCODEs File Status Interview Prep Contact
← Back to SQLCODE Reference
Error

SQLCODE -803

Duplicate key on INSERT/UPDATE

Explanation

Value would cause duplicate in unique index or primary key.

Solution

Check for existing key before insert. Use MERGE or ON DUPLICATE KEY UPDATE.

Example

INSERT duplicate primary key value