also remember, you cannot update a primary key when it has matching forei

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?

Question Posted / guest

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

Please Help Members By Posting Answers For Below Questions

How to test SQL -911 error while developing COB-DB2 program

7436

What happens in bind step in a db2 program?

913

What is the maximum size of a char data type in db2?

959

Why cursor is used in db2?

983

List out the buffer pools in db2

1017

Define predicate?

1062

Where do you specify them?

1159

What are the 2 sqlcodes that are returned?

1128

What is commit in db2?

995

How to execute stored procedure in db2 command editor?

983

Why do we need reorg in db2?

918

Explain about rct.

1024

What is check constraint in db2?

1011

When the like statement is used?

1156

What is query_cache_limit?

927