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
- 9434 Views
- I also Faced
- E-Mail Answers
Answer Posted / purushotham
Obviously it will close all the cursors.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain the function done by data manager?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
can all users have the privilage to use the sql statement select * (dml)?
What do you mean by rollback?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What are the benefits of using the db2 database?
Name the various locking levels available?
What is db2 connect?
What are the different types of base tables?
How to find the maximum value in a column in the db2 database?
Mention the location where the output received from explain statement is stored.
What is bind in db2?
What is buffer pool?
What is scrollable cursor in db2?
Which component is responsible for db2 startup and shutdown?
