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



assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 ..

Answer / anonumous

it would be FETCH 300 ONLY

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  


There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,


what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,


What's The Error Code For Unique Index Voilation?

0 Answers   IBM,


How to resolve -805 error in DB2?

1 Answers   Cap Gemini,






what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,


What is host variable in db2 cobol?

0 Answers  


Describe what a storage group(STOGROUP) is?

2 Answers  


if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,


I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  


Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,


Can you use max on a char column?

0 Answers  


Categories