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 usage pointer in cobol?

3 Answers   IBM,


What is the difference between group by and order by?

2 Answers   IBM, TCS,


How do I add a column to a table in db2?

0 Answers  


What is a db2 package?

0 Answers  


When will you chose to run RUNSTATS?

1 Answers  


How would the varchar column remarks defined?

0 Answers  


What is meant by dclgen?

0 Answers  


how can u understand the end of the table ?

1 Answers   TCS,


How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,


What is the role of data manager in the db2 database?

0 Answers  


Define db2 and its databases?

0 Answers  


How many buffer pools are available in db2?

2 Answers  


Categories