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

how to fetch multiple records without using cursor

Answer Posted / chakradhar patra

Yes its possible in NATURAL using MULTI-FETCH Option.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2037


What is copy pending and check pending in db2?

964


What are the prerogatives?

1032


How to find the number of rows in a db2 table?

1084


What is the difference between nvl and coalesce?

1023


What is a db2 table?

969


can we view the access paths created by dbrm ? how ? thx

6996


Where can you declare a cursor in a cobol-db2 program?

1023


What is reorg?

1088


What db2 400?

1118


What is reorg and runstats in db2?

1168


What is the maximum size of varchar data type in db2?

1083


What is scrollable cursor in db2?

1014


What is a storage group (stogroup)?

1200


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3108