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.