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
- 9515 Views
- I also Faced
- E-Mail Answers
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
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is ibm db2 used for?
How to check sequence on a table in db2?
How does a cursor work?
What is reorg?
What is the difference between dbm cfg and db cfg file in db2 ?
What are the bind parameters ibm db2?
What r the comman abends in db2, jcl and cobol???????
What is bind and rebind in db2?
Before you give the explain statement, what are the prerogatives?
What are the various isolation levels possible?
What is the clustering index in the db2 database?
define clustering index.
What is a collection in db2?
What is the role of data manager in the db2 database?
