Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve -803 sql code in DB2?
- 3 Answers
- 44361 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 |
Explain about cursor stability?
What is db2 instance?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
What is sqlcode -922 ?
What is meant by dclgen?
What are the two types of logging in the db2 database? Explain them.
What is a base table?
What is difference between isnull and coalesce?
What is Declaration Generator(DCLGEN)?
Is it possible using max on a char column?
What is the SQL Communications Area and what are some of its key fields?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
COBOL 
