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
26841 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

Can we update view in db2?

1002

What is package in db2 mainframe?

987

What is the use of runstats in db2?

1109

What is rct?

1233

How do we specify index to include or not during bind process.

2126

Give a brief description of db2 isolation levels?

1072

How to take backup of table in db2?

1074

What is db2 instance?

1094

When do you specify the isolation level?

1030

what is diffrence b/w file-aid tool and file-aid utility???

4891

How to run db2 command in windows?

1193

What is the picture clause of null indicator variable?

1138

How can you quickly find out the # of rows updated after an update statement?

1047

How can you do the explain of a dynamic sql statement?

1069

What is a bind in db2?

1042