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 corelated subquerry?

1062

List down the types of triggers in the db2 database?

960

Name the various locking levels available?

1033

How do I import data from excel to db2?

999

what is the sqlcode -501

12908

What does runstats do in db2?

1020

Which isolation level provides highest data integrity?

1036

What is runstats db2?

961

What are the contents of dclgen?

1053

Before you give the explain statement, what are the prerogatives?

968

What is role in db2?

1034

What is cursor with hold option in db2?

1007

How to find the number of rows in db2 tables?

992

what are bind concepts in db2 cobol?

1031

How to rename a table in DB2 ?

1023