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 buffer pool?

1106


What is universal database?

1069


What is null value in db2?

1024


Is db2 free?

1094


Why select is not preferred in embedded sql programs?

1299


How to access db2 tables in mainframe?

1051


What is bind plan?

1048


How can you quickly find out the # of rows updated after an update statement?

1046


What is the maximum length of sqlca?

1529


What is db2 bind?

1082


What is cloudant database?

1096


What is sqlca?

1073


What is package in db2 mainframe?

987


What is a dbrm in db2?

1020


What is cascading rollback?

1214