How to resolve -803 sql code in DB2?
Answers were Sorted based on User's Feedback
Answer / lakshmi
This error is thrown when you try to insert a row with
existing primary key i.e.Duplicate. If you want to insert
the row either you should delete the already existing row
and insert the new row or update the same row with the new
values for other fields
Is This Answer Correct ? | 22 Yes | 8 No |
Answer / venkata sastry
The SQL - 803 error occurs on the violation of a UNIQUE
constraint. Update the record if it already exists rather
inserting new one.
Is This Answer Correct ? | 15 Yes | 6 No |
Answer / lu
Before to insert, it's better to select(retrieve),test
sqlcode when 100 insert when 00 update whenever send
message and abend...You don't have an heache....
Is This Answer Correct ? | 5 Yes | 3 No |
How to resolve -917 sql code in DB2?
What is dbrm library?
What is bufferpool in db2?
What is iseries database?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is access path in db2?
What are the 2 sqlcodes that are returned?
What is JOIN and different types of JOIN.
how to resolve -818 error. how to see timestamp token in load module and plan
What is dbrm? What it contains?
Is db2 a programming language?
When is the authorization check on DB2 objects done - at BIND time or run time?