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. 

When does Sql code -803 comes?

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.

How the system behaves for sqlcode of -803?

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

How to solve sql code of -803? ; ; ; ;

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.