How to resolve -803 sql code in DB2?
- 3 Answers
- 43081 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 |
What is runstats db2?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Suppose if I need to update a column, how you do that using cursor?
what is the name of the default db2 catalog database?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
when does the SQL statement gets executed when you use cursor in the application programming ?
What is declare cursor?
what is the responsibility of the construction superintendent
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
Which isolation level provides maximum concurrency?
What is UNION,UNION ALL?
COBOL 
