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
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is dbrm? What it contains?
What is check constraint. Explain with example.
What is coalesce in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What are the bind parameters ibm db2?
How can you find out the # of rows updated after an update statement?
What is check constraint in db2?
What are the contents of dclgen?
How can you classify the locks in db2?
What is the difference between spufi and qmf?
Why do we use cursor?
How does a cursor work?
How to execute stored procedure in db2 command editor?
What does a deadlock mean in DB2?