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 cobol db2?
What is bind and rebind in db2?
What is the function of logging in the db2 database?
What is buffer pool in the db2 database?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is check constraint. Explain with example.
What is buffer pool?
What is lock escalation in db2?
What is null indicator in db2?
What is a buffer in memory?
Can we delete records from view?
What is null value in db2?
How do I create a view in db2?
Describe major components of db2?
What is scrollable cursor in db2?