Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is the error code for Unique Index Violation?




457
views
asked mar September 2, 2014 12:03 PM  

What is the error code for Unique Index Violation?


           

1 Answers



 
answered By Mswami   0  
-803.

AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE THE INDEX IN INDEX SPACE indexspace-name CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS Xrid.

Suggestion: Verify DB INDEX and, if needed, change the statement to an UPDATE.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert