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

also remember, you cannot update a primary key when it has
matching foreign key values.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What os does db2 run on?

759


What does db2 blu stand for?

901


Define predicate?

877


How do I delete a table in db2?

834


What is rebind in db2?

783


Mention some fields that are a part of sqlca.

793


List down the types of triggers in the db2 database?

786


Why select is not preferred in embedded sql programs?

955


Define db2 and its databases?

826


What are db2 tables?

869


What is the use of reorg in db2?

835


What are the different types of base tables?

777


What are the contents of dclgen?

856


Explain in detail about buffer manager and its functionalities?

794


Give a brief description of db2 isolation levels?

798