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

How do I delete a table in db2?

1089


What is a collection in db2?

1045


What do you mean by commit and rollback?

1051


How many types of page locks can be held in db2?

1044


How does cobol compile db2 program?

1081


What is precompiler in db2?

1026


Explain package in db2 and its advantages?

1225


What db2 400?

1206


Which are the db2 tools to protect integrity of the database?

1129


How do you concatenate the firstname and lastname from emp table to give a complete name?

1077


What are db2 tables?

1133


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?

2398


Is ibm db2 open source?

1082


What is null indicator in cobol db2?

1073


Can there be more than one cursor open for any program?

1177