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
- 9484 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
When do you specify the isolation level?
Which component is responsible for db2 startup and shutdown?
How does coalesce work?
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.
How to take backup of table in db2?
What is dbrm in db2 database?
What is a db2 tablespace?
What is cursor stability in db2?
What is the purpose of rollback and commit?
Which component is used to execute the sql statements?
How can you do the explain of a dynamic sql statement?
What's The Percentage Free Space ?
What is a system catalog table in db2?
What is the maximum size of varchar data type in db2?
How to connect to db2 database from windows command line?
