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

Is db2 relational database?

0 Answers  


What is the maximum No of rows per page?

0 Answers   IBM,


How does DB2 determine what lock-size to use?

2 Answers  


Explain transactions, commits and rollbacks in DB2.

3 Answers  


What are the advantages of using a PACKAGE?

2 Answers  






When would you prefer to use VARCHAR?

3 Answers  


What is usage pointer in cobol?

3 Answers   IBM,


How do I start db2 in windows?

0 Answers  


How do I delete a table in db2?

0 Answers  


wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,


How to solved 818 error

4 Answers   Keane India Ltd, Wipro,


What happens in bind step in a db2 program?

0 Answers  


Categories