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
- 9652 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sridhar
COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.
| Is This Answer Correct ? | 37 Yes | 0 No |
Answer / srisri
COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / r.l.v.krishna
COMMIT WILL CLOSE ALL THE CURSORS IF U R NOT MENTIONED WITH HOLD OPTION IN THE DECLARATION PART OF THE CURSOR....
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the logical entity between plan and Package?
Can we declare DB2 HOST variable in COBOL COPY book?
List some fields from sqlca?
What does reorg do in db2?
What is the difference between oracle and db2?
How do you do the EXPLAIN of a dynamic SQL statement?
How to find last record before record through SQLRPGLE?
what is check point and restart Logic ? why do we go for that ??
What is syscat in db2?
What is DCLGEN ?
What is netezza database?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
COBOL 
