DB2 Error Code -803 – SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by “1” constrains table “%s” from having duplicate rows for those columns.

In this post, you’ll learn about the DB2 error -803-SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by “1” constrains table “%s” from having duplicate rows for those columns. and the reason why you are receiving the error message and how to fix it

How does this Error Message Looks like

-803 – SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by “1” constrains table “%s” from having duplicate rows for those columns.

Reason for the Error & Solution

Duplicate values have been inserted into a column that has a UNIQUE constraint. It is the responsibility of the application to deal with prevention of insertion of duplicate values.