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

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

Answer Posted / anonumous

it would be FETCH 300 ONLY

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between alias and synonym in db2?

1072


Which is faster delete or truncate?

1070


What is the physical storage length of timestamp data type?

1027


What is host variable in db2 cobol?

1032


Explain the contention situations caused by locks?

1014


What is the cobol picture clause of the db2 data types date, time, timestamp?

1012


what is utility for parm lib

2311


What is the use of reorg in db2?

1027


What is dclgen (declaration generator)?

1012


Why cursor is used in db2?

986


Comment whether the cursor is closed during commit or not.

1042


How do I import a csv file into db2?

938


What is db2 command?

965


How to create backup table in db2?

1044


What are the prerogatives?

1016