Answer Posted / 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 |
Post New Answer View All Answers
What is an instance in db2?
What is buffer pool?
What is the information associated with sysibm.syslinks table?
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 db2? Explain.
How can deadlocks be resolved?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is the use of dclgen in db2?
Define sqlca.
What is clone table?
How to restart a DB2 program?
How many databases are there?
What is a system catalog table in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How to test SQL -911 error while developing COB-DB2 program