what is the syntax for FOR UPDATE CLAUSE in cursor
declaration and how can u update using cursor? is it
possible to update multiple rows at a time.
- 2 Answers
- 11158 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / vaneesh khurana
If one wants to update multiple rows simply write a querry,
instead of using cursor.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between drop table and delete table?
When the like statement is used?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What does db2 mean?
Is ibm db2 open source?
What does reorg do in db2?
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 ?
Can you tell me how can you find out the # of rows updated after an update statement?
What is a trigger in the db2 database?
Explain the function done by data manager?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is a Foreign Key?
What is the role of data manager in the db2 database?
How many types of page locks can be held in db2?
What is rebind in db2?
