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
- 9664 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 |
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is scrollable cursor in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
Could anyone clearly explain the diference between sub query and correlated sub query?
What is an instance in db2?
What is cursor with hold option in db2?
What is sqlcode -922 ?
What is a DB2 bind?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
How to see the structure of db2 table??
What is netezza database?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
COBOL 
