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
- 9485 Views
- I also Faced
- E-Mail Answers
Answer Posted / srisri
COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain package in db2 and its advantages?
What is db2 command?
Can one database have multiple instances?
What does runstats do in db2?
How to execute stored procedure in db2 command editor?
Where do you specify them?
What is plan in cobol db2?
What is cascading rollback?
What is a system catalog table in db2?
What is the maximum size of a char data type in db2?
Explain various types of locks in db2?
What are the different types of base tables?
What are the various data types available in db2?
What is a cursor in programming?
What is dclgen in db2?
