Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve -803 sql code in DB2?
- 3 Answers
- 44198 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 find last record before record through SQLRPGLE?
What is bind package and plan in db2?
What is the significance of DB2 free space and what parameters control it?
What is image copy?
What is an alias and how does it differ from a synonym?
How to see the structure of db2 table??
What is DCLGEN ?
Name the various locking levels available?
How do I delete a table in db2?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
How to test SQL -911 error while developing COB-DB2 program
what is diffrence b/w file-aid tool and file-aid utility???
COBOL 
