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 / deepak
First u will need to drop the index and then make the
required changes to PK and later again create the
index,Make sure u have all the conditing to for PK fine.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is utility for parm lib
What is clone table?
How can the duplicate values be eliminated from db2 select?
What is a page in db2?
What is bufferpool in db2?
Which isolation level provides maximum concurrency?
what is a corelated subquerry?
How to resolve deadlock issue
What is the difference between cursor and select statement?
What is the purpose of rollback and commit?
Explain package in db2 and its advantages?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a db2 collection?
Why select is not preferred in embedded sql programs?