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
- 7432 Views
- I also Faced
- E-Mail Answers
Answer Posted / srisri
COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between oracle and db2?
What is the default page size of buffer pools?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
List down the data types in the db2 database.
What is difference between rollback and commit?
what is a corelated subquerry?
What is meant by dclgen?
How to check sequence on a table in db2?
How do I delete a table in database?
How do we specify index to include or not during bind process.
Which are the db2 tools to protect integrity of the database?
What is a dbrm in db2?
How to create db2 table in mainframe?
What is dpf in db2?
