COBOL · DB2 SQLCODE

SQLCODE -803

What does SQLCODE -803 mean in COBOL?

Duplicate key value. An INSERT or UPDATE produced a value that duplicates an existing value in a column or set of columns constrained to be unique, such as a primary key or a unique index.

SQLCODE -803DB2 for z/OS · Db2 (embedded SQL in COBOL)

Condition

Duplicate key value. An INSERT or UPDATE produced a value that duplicates an existing value in a column or set of columns constrained to be unique, such as a primary key or a unique index.

Fix

Check the key value being inserted or updated against what already exists, and decide whether the intent was actually an UPDATE rather than an INSERT.

Pending source verification. Not yet checked against official documentation.

Related db2 sqlcode