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.