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
What is the difference between drop table and delete table?
How can you find out the # of rows updated after an update statement?
what is db2 restart?
How is the value function used?
How do I delete a column in db2?
What is host variable?
What is the use of value function?
How would the varchar column remarks defined?
What are the two types of logging in the db2 database? Explain them.
Is the primary key a clustered index?
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?
What are the bind parameters ibm db2?
What is the default page size of buffer pools?
What is precompiler in db2?
What are the various isolation levels possible?