First u will need to drop the index and then make the required changes to

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

8 Answers
26472 Views
I also Faced
E-Mail Answers

Answer Posted / deepak

First u will need to drop the index and then make the
required changes to PK and later again create the
index,Make sure u have all the conditing to for PK fine.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

define clustering index.

980

Which isolation level provides maximum concurrency?

1093

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1978

What is the use of runstats in db2?

1025

Outputs of explain are with matchcols = 0. What does this signify?

997

How to check last update on table in db2?

1009

Explain about mirror activator disk mirroring?

962

Mention data types used in db2 ?

1109

what is a corelated subquerry?

1067

What is the physical storage length of the data types date, time, and timestamp?

1042

What is a storage group (stogroup)?

1192

What is the picture clause of null indicator variable?

1086

What is page size in db2?

908

What is an instance in db2?

989

What is blu acceleration in db2?

1018