Is it possible to update a primary key value? If not, what
is the error code given? If yes, can more than 1 primary
key column be updated at a time?
Answer Posted / guest
Primary key value can be updated as well provided the value
you update it with identifies it uniquely.
| Is This Answer Correct ? | 28 Yes | 4 No |
Post New Answer View All Answers
How do I delete a table in db2?
How to run db2 command in windows?
When reorg is used?
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.
How is a typical db2 batch pgm executed?
How can deadlocks be resolved?
Define declaration generator (dclgen).
What is the role of data manager in the db2 database?
How do I change the column size in db2?
What is innodb buffer pool?
Can you tell me how can you find out the # of rows updated after an update statement?
Mention the various locks that are available in db2.
i want to maintain uniqueness on pdf without make lf??????????
How do I delete a table in database?
How do I add a column in db2?