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 a db2 schema?

1024


How to view db2 table structure?

829


Where can you declare a cursor in a cobol-db2 program?

815


Explain the benefits you can get from mainframe connect?

768


What db2 400?

944


Which component is responsible for processing sql statements and selecting access paths?

930


What is the advantage in De-normalizing tables in DB2?

978


What do you mean by rollback?

783


What is coalesce in db2?

898


What is a db2 tablespace?

834


How to take backup of table in db2?

849


What are host variables in db2?

845


What is precompiler in db2?

816


Explain db2.

853


What are packages in db2?

827