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?
Answer Posted / guest
Primary key value can be updated as well provided the value
you update it with identifies it uniquely.
| Is This Answer Correct ? | 28 Yes | 4 No |
Post New Answer View All Answers
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How would the varchar column remarks defined?
How can you find out the # of rows updated after an update statement?
What is the clustering index in the db2 database?
How to execute stored procedures?
What is a db2 package?
What is release/acquire in bind?
What is declare cursor?
How can we retrieve the total number of records in RPG & CLLE?
What is bufferpool in db2?
Explain various types of locks in db2?
what is the role of the cursor in db2?
What action db2 takes when a program aborts in the middle of a transaction?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the role of schema in the db2 database?