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
- 9241 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 are concurrency issues?
What is the difference between spufi and qmf?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is sqlca?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What are the uses of db2 optimizer?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How to retrieve rows from a db2 table in embedded sql?
Define buffer pool.
i want to maintain uniqueness on pdf without make lf??????????
Comment whether the cursor is closed during commit or not.
What are the full forms of spufi and dclgen and why are they used?
What are the benefits of using the db2 database?
What is the maximum number of columns in a db2 table?
