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 |
What is the specific need of Plan and..where are the tables in DB2 are physically saved
can all users have the privilage to use the sql statement select * (dml)?
What are the bind parameters ibm db2?
What is the advantage in De-normalizing tables in DB2?
How do I optimize a query in db2?
What is a db2 package?
Explain transactions, commits and rollbacks in DB2.
What is a NULL value? What are the pros and cons of using NULLS?
how to unload different table data into different gdg files/ vsam files.
What is db2 purescale?
Can I use LOCK TABLE on a view?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?