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

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,


What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  


What is the max length of sqlca?

0 Answers  


Define db2 and its databases?

0 Answers  


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  






what is load and unload in db2

1 Answers   IBM,


wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,


What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,


i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  


What is syscat in db2?

0 Answers  


I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  


In terms of DB2 indexing, what is the root page?

1 Answers  


Categories