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

Explain transactions, commits and rollbacks in DB2.

3 Answers  


How to handle null values in db2

4 Answers  


What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,


What is a DB2 bind?

3 Answers  


What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,






how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,


what is different three logs in DB2?

1 Answers   Syntel,


What is lock contention?

1 Answers  


How would one remove old reorg information from the DB2 catalog?

2 Answers  


What is a collection?

3 Answers  


What will happen, while trying to close the closed cursor.

0 Answers  


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  






Categories