I have 3 cursors declared. Cursor1 retieves some data.
Based on this curso2 will also fetches some data. In cursor3
(using for some updation) I'm using the data retrieved by
the above 2 cursor. My question is, while working with
cursor3, periodically if I give commit, will all the three
crsors will be closed or only cursor3 will be closed?
- 4 Answers
- 7405 Views
- I also Faced
- E-Mail Answers
Answer Posted / purushotham
Obviously it will close all the cursors.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is a bind card?
What is the result of open cursor statement?
How do I add a column in db2?
What is cursor with hold option in db2?
Why do we need reorg in db2?
How to check table size in db2 sap?
If I have a view which is a join of two or more tables, can this view be updateable?
Discuss about db2 bind?
What is the use of value function?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Is the primary key a clustered index?
Is db2 relational database?
What is host variable?
Define db2 and its databases?
What is meant by union and union all?
