Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve -803 sql code in DB2?
- 3 Answers
- 44406 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 a subselect? Is it different from a nested select?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
What is null indicator in db2?
What's The Error Code For Unique Index Voilation?
How would you print the output of an SQL statement from SPUFI?
Can a array declared with an index be displayed(readable format) in spool?
What is a clustering index?
What is an access path?
What is catalog database in db2?
Define check constraint.
COBOL 
