Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 26442 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
Where can you declare a cursor in a cobol-db2 program?
What do you mean by commit and rollback?
What is table space in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
List out the three types of page locks that can be held.
What does db2 stand for?
What is the use of runstats in db2?
What is reorg?
Which are the db2 tools to protect integrity of the database?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the role of schema in the db2 database?
What is the difference between cursor and select statement?
What is db2 catalog database?
Is db2 free?
What is isolation level in db2?
