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

Ans 3 is correct. If the key already present, while
updating it will show the sql code as = -803.

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the various locks that are available in db2.

824


What is db2?

954


What is precompiler in db2?

811


What is cursor with hold option in db2?

852


What are bind parameters in db2?

834


What is consistency token in db2?

897


What are the 2 sqlcodes that are returned?

920


What are the prerogatives?

836


What is coalesce in db2?

893


What is table space in db2?

817


What is the use of value function?

881


What is an instance in db2?

810


Define data page.

857


What is db2 stogroup?

927


What is meant by union and union all?

816