Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9477 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 database alias db2?
What does reorg do in db2?
What is runstats utility in db2?
How does db2 sample database connect?
Who uses db2?
How and when does the db2 enforces the unique key?
How to execute stored procedure in db2 command editor?
What is a Foreign Key?
Why cursor is used in db2?
What is declare cursor?
How to test SQL -911 error while developing COB-DB2 program
What is dbrm library?
What is db2 plan table?
What are the various isolation levels possible?
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 ?
