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
also remember, you cannot update a primary key when it has
matching foreign key values.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is dpf in db2?
Mention the definition of cobol in varchar field.
What does a deadlock mean in DB2?
What is dbrm? When it will be created?
What happens in bind step in a db2 program?
What is the role of schema in the db2 database?
Before you give the explain statement, what are the prerogatives?
Which components manage deadlocks in db2?
What are the various isolation levels possible?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
On which levels locks can be applied?
How do I optimize a query in db2?
What is the advantage in De-normalizing tables in DB2?
How do I change the column size in db2?
What is the information associated with sysibm.syslinks table?