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


Please Help Members By Posting Answers For Below Questions

What is the difference between drop table and delete table?

548


How can you find out the # of rows updated after an update statement?

637


what is db2 restart?

1689


How is the value function used?

600


How do I delete a column in db2?

676






What is host variable?

590


What is the use of value function?

622


How would the varchar column remarks defined?

633


What are the two types of logging in the db2 database? Explain them.

573


Is the primary key a clustered index?

607


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?

1936


What are the bind parameters ibm db2?

622


What is the default page size of buffer pools?

644


What is precompiler in db2?

585


What are the various isolation levels possible?

645