Sql Code -803
SQL CODE -803
What is 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.