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 / sujeesh
Primary key column cannot be updated,because it is used as
the key field to find out a row uniquely.
| Is This Answer Correct ? | 17 Yes | 22 No |
Post New Answer View All Answers
How can you count the number of rows from a table tab?
How is the value function used?
Explain about rct.
On which levels locks can be applied?
What is the difference between bind and rebind in db2?
What is the maximum size of varchar data type in db2?
What is db2 purescale?
How many databases can be created inside an instance in db2 ?
Mention some fields that are a part of sqlca.
What is null in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Is the primary key a clustered index?
What is lock escalation in db2?
What is a db2 package?
How do you simulate the explain of an embedded sql statement in spufi/qmf?