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 a subprogram B calling from mainprogram A.I have
opened a cursor in A ,Can i fetch the same cursor in
subprogram B , If yes , Please explain the reason?



I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same..

Answer / harsha

I feel yes, we can fetch the same cursor in the same
program.
Cursor can be closed in three ways.
1 When you explicitely close trhe cursor.
2 Issuing commit systement.
3 After execution of an application program.

In our situation, none of the above mentioned case is
getting true.

Is This Answer Correct ?    11 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is tablespace?

3 Answers  


how can i pull up a query which was previously stored in qmf

3 Answers  


Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  


What is read-only cursor?

1 Answers  


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  


What is schema in db2?

0 Answers  


How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,


What do you mean by storage group (stogroup)?

0 Answers  


Can we insert update delete in view?

0 Answers  


Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,


How do I create a view in db2?

0 Answers  


What is a cursor and what is its function?

2 Answers  


Categories