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
- 7411 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
What is runstats utility in db2?
How to create db2 table in mainframe?
What is the difference between spufi and qmf?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is a db2 table?
How to get the ddl of a table in db2?
Comment whether the cursor is closed during commit or not.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the meaning concurrency in the db2 database?
What is universal database?
What kind of database is db2?
How do I delete a column in db2?
What is precompiler in db2?
What is netezza database?
What are the 2 sqlcodes that are returned?
