Ans 3 is correct. If the key already present, while updating it will show

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

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

Please Help Members By Posting Answers For Below Questions

What is a db2 table?

958

How to connect to db2 database from windows command line?

1003

What is host variable in db2 cobol?

1032

Explain about mirror activator disk mirroring?

961

What is difference between isnull and coalesce?

1010

What is lock escalation in db2?

969

What is db2 and what is the use of db2 optimizer?

996

How to resolve deadlock issue

19874

what is the role of the cursor in db2?

1002

How to fetch the last row from the table in SQL (db2)?

1590

What is meant by explain?

1064

What is runstats db2?

967

How can the duplicate values be eliminated from db2 select?

1044

How many databases can be created inside an instance in db2 ?

981

What is null in db2?

950