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...


Can we use select query in a loop to fetch multiple rows in
a COBOL PROGRAM? If so, what is the advantage of cursor?



Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the adv..

Answer / hitendra valluri

As per my knowledge if we loop the select query it retrieves the same data untill we explicitly handle the where clause to retrieve the rows. Unlike select CURSOR fetches all the rows and allows the program to process 1 at a time.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is a DB2 access path?

1 Answers  


What is rct?

0 Answers  


could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  


How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,


What is clone table?

0 Answers  


Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,


Explain packages.

0 Answers  


What is table space in db2?

0 Answers  


what is the name of the default db2 catalog database?

3 Answers   IBM,


What are the 2 sqlcodes that are returned?

0 Answers  


wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,


What is the physical storage length of timestamp data type?

0 Answers  


Categories