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 / haribabu

yes, it is possible, move 'value' to ws-eno. Here ws-eno is
primary-key.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

B37 abend during spufi?

978


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

742


what is the responsibility of the construction superintendent

1660


What does sqlcabc has?

627


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

629






What are the prerogatives?

612


Name the various locking levels available?

631


What is a collection in db2?

579


What is phantom read in db2?

636


What os does db2 run on?

570


List down the data types in the db2 database.

632


What is the difference between dbm cfg and db cfg file in db2 ?

999


Explain dclgen.

722


What is the difference between bind and rebind in db2?

847


How to connect to db2 database from windows command line?

560