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?
Answer Posted / sridhar
COMMIT will close all the cursors, if the cursors are not
delcared using 'WITH HOLD'.
Is This Answer Correct ? | 37 Yes | 0 No |
Post New Answer View All Answers
Who uses db2?
What happens in bind step in a db2 program?
List down the data types in the db2 database.
What is the use of runstats in db2?
How can record locking be achieved in those DB2 versions which do not support it?
How do you find the maximum value in a column in db2?
What is the physical storage length of date data type?
What is a storage group (stogroup)?
Name the various locking levels available?
What is difference between isnull and coalesce?
How to connect to db2 database from windows command line?
What is db2 and what is the use of db2 optimizer?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is db2 stogroup?
What is the syntax for seeing the columns and data types of a table in the db2 database?