Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve -803 sql code in DB2?
- 3 Answers
- 44395 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 can the Locate option of the Repair Utility accomplish?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
How to restart a DB2 program?
How would you print the output of an SQL statement from SPUFI?
What is rct?
What are the Isolation levels possible ?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
Give some example of statistics collected during RUNSTATS?
pls explain the precompilation process of cobol-db2 pgm
How to define the data items to receive the fetch items for the SQL?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
COBOL 
