Answer Posted / 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 |
Post New Answer View All Answers
Explain how can you do the explain of a dynamic sql statement?
Which command is used to remove all rows from a table?
What is db2 instance?
Explain the contention situations caused by locks?
What are the rules for db2 programming?
Define data page.
What db2 400?
Explain the contents that are a part of dclgen.
What is commit in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
what is the sqlcode -501
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is temporal table in db2?
Explain the function done by data manager?
How do you stop a db2 database in linux?