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
- 9651 Views
- I also Faced
- E-Mail Answers
Answer Posted / purushotham
Obviously it will close all the cursors.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Is db2 a programming language?
What is the maximum number of columns in a db2 table?
How to view db2 table structure?
What are the benefits of using the db2 database?
List down the data types in the db2 database.
What is sqlca’s maximum length?
What is the difference between cursor and select statement?
What do you mean by cursor?
Comment whether the cursor is closed during commit or not.
What is the usage of open cursor command?
What is check constraint in db2?
What is reorg and runstats in db2?
What is lock escalation in db2?
What is bufferpool in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
