DB2 Error Code 1 – ORA-00001: unique constraint (%s) violated

In this post, you’ll learn about the DB2 error 1-ORA-00001: unique constraint (%s) violated and the reason why you are receiving the error message and how to fix it

How does this Error Message Looks like

1 – ORA-00001: unique constraint (%s) violated

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.