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
- 26878 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
What is meant by explain?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is deadlock in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is meant by dclgen?
What language is db2 written in?
Which component is responsible for db2 startup and shutdown?
Define declaration generator (dclgen).
What is dbrm? What it contains?
How to fetch the last row from the table in SQL (db2)?
Can we insert update delete in view?
What is a Foreign Key?
What is cursor stability in db2?
How many databases can be created inside an instance in db2 ?
Mention the downsides of page level lock.
