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
What is the connection string to connect to the DB2 Database ?
Outputs of explain are with matchcols = 0. What does this signify?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How do I copy a table in db2?
On which levels locks can be applied?
What is the physical storage length of timestamp data type?
What are the prerogatives?
Mention some fields that are a part of sqlca.
What is the use of db2?
How to create db2 table in mainframe?
Name the various locking levels available?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is coalesce in db2?
How to rename a table in DB2 ?