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
- 9503 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 does sqlcabc has?
define clustering index.
What is db2 look?
Why select is not preferred in embedded sql programs?
What is meant by explain?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What do you mean by rollback?
What is explain in db2?
Define predicate?
What is a buffer in memory?
Mention data types used in db2 ?
How do you pull up a query which was previously saved in qmf?
What is the physical storage length of the data types date, time, and timestamp?
How can record locking be achieved in those DB2 versions which do not support it?
What are the various isolation levels possible?
