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?
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 database manager in db2?
How to compare data between two tables in db2?
How and when does the db2 enforces the unique key?
List out the buffer pools in db2
What db2 400?
What is cloudant database?
What is role in db2?
What is null indicator in db2?
How do I import a csv file into db2?
What is the latest version of ibm db2?
What is bufferpool in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is scrollable cursor in db2?
What are union and union all?
What is the information associated with sysibm.syslinks table?