Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answer Posted / purushotham

Obviously it will close all the cursors.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database manager in db2?

1024


How to compare data between two tables in db2?

1088


How and when does the db2 enforces the unique key?

1084


List out the buffer pools in db2

1076


What db2 400?

1195


What is cloudant database?

1101


What is role in db2?

1109


What is null indicator in db2?

1114


How do I import a csv file into db2?

992


What is the latest version of ibm db2?

1269


What is bufferpool in db2?

1055


can all users have the privilage to use the sql statement select * (dml)?

1174


What is scrollable cursor in db2?

1056


What are union and union all?

983


What is the information associated with sysibm.syslinks table?

1125