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
- 9658 Views
- I also Faced
- E-Mail Answers
Answer Posted / sridhar
COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.
| Is This Answer Correct ? | 37 Yes | 0 No |
Post New Answer View All Answers
What is dbrm? What it contains?
What are the full forms of spufi and dclgen and why are they used?
How do I add a column in db2?
is it compulsory commitment control in journal?
Define sqlca.
Is db2 a mainframe?
What is ibm db2 connect?
Are views updateable?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to find the number of rows in db2 tables?
How would you find out the total number of rows in a db2 table?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
If I have a view which is a join of two or more tables, can this view be updateable?
What are the uses of db2 optimizer?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
