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
- 9430 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
Explain about open switch business continuity software?
Which isolation level provides maximum concurrency?
What is the difference between spufi and qmf?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is host variable?
What is temporal table in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Explain about mirror activator disk mirroring?
How does db2 sample database connect?
List out the three types of page locks that can be held.
Which component is responsible for processing sql statements and selecting access paths?
Explain the function of data manager.
Mention some fields that are a part of sqlca.
What os does db2 run on?
