Sql Code -803

SQL CODE -803

SQL code of -803 comes due to duplication of rows in a table which has a unique contraint defined on it. 

 

The three condition in which sqlcode of -803 can come are as below:-

 

 

Insert:- You/application programs are  trying to insert a duplicate record in a table which is constrained to have unique records.

 

Update:- You/application programs are trying to update an existing record in a table (which has a constrained to have unique records)

that will cause the duplication of record in the table.

 

Delete:- You/application programs are trying to delete an existing record in a parent table which cascades the deletion as set "Null" to child table (which has a constrained to have unique records) and this action causes duplication of records in the child table.

 

The system does not perform the requested actions and the table remains unchanged.

Check for the condition that are causing the duplication of rows in the table/objects. You may refer to the unique indexes set on the table to identify the constraints.