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

How to execute stored procedure in db2 command editor?

766


What is the role of data manager in the db2 database?

869


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1811


What is dbrm? When it will be created?

786


Is schema the same as database?

845


Name the lockable units in DB2?

914


Explain various types of locks in db2?

900


What is temporal table in db2?

819


i want to maintain uniqueness on pdf without make lf??????????

1920


What are the prerogatives?

813


What is buffer pool and list some of them?

815


What is the syntax for creating a table in the db2 database?

887


What is the reason behind not using select * in embedded sql programs?

862


What is consistency token in db2?

879


What is null indicator in db2?

864