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
- 9507 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
Mention the various locks that are available in db2.
What is the default page size of buffer pools?
What is a cursor in programming?
What are the contents of dclgen?
How to execute stored procedure in db2 command editor?
Define db2 and its databases?
What are the rules for db2 programming?
What os does db2 run on?
How do you pull up a query which was previously saved in qmf?
How can you quickly find out the # of rows updated after an update statement?
What is view db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What types of tables are there in the db2 database?
How to check sequence on a table in db2?
What is sqlca’s maximum length?
