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?
Answer Posted / 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 |
Post New Answer View All Answers
Which component is responsible for processing sql statements and selecting access paths?
Explain correlated sub-queries.
Comment whether the cursor is closed during commit or not.
What are iseries servers?
What are the different types of base tables?
What is a db2 tablespace?
What is ibm db2 client?
What is the maximum size of a char data type in db2?
What is package in cobol db2?
What is dclgen in db2?
What is a db2 cursor?
How to execute stored procedures?
What are the various isolation levels possible?
What is db2 plan table?
What is phantom read in db2?