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
- 9500 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 buffer pool and list some of them?
can all users have the privilage to use the sql statement select * (dml)?
Can there be more than one cursor open for any program?
Name the lockable units in DB2?
Define predicate?
How can you count the number of rows from a table tab?
What is the purpose of rollback and commit?
What is host variable?
What is the maximum length of sqlca?
Explain about dbrm.
What is the syntax for creating a table in the db2 database?
What is ibm db2 connect?
What are packages in db2?
What is bind in db2?
What is concurrency?
