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

What is DCLGEN ?

3 Answers  


How can the duplicate values be eliminated from db2 select?

0 Answers  


How do I add a column in db2?

0 Answers  


what is plan? is plan executable or package?

4 Answers  


What are the isolation levels possible ?

3 Answers  






how to identify the pseudo conversation by seeing the program

2 Answers   DELL,


How does DB2 use multiple table indexes?

1 Answers  


What is a plan and package in db2?

0 Answers  


Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,


i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,


Are views updateable?

0 Answers  


Explain various types of locks in db2?

0 Answers  


Categories