assume ther are 5000 records in a database and want to fetch using cursor. curso

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

Question Posted / akila

1 Answers
3273 Views
TCS, I also Faced
E-Mail Answers

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 db2 bind process?

0 Answers

What are the contents of a DCLGEN?

4 Answers MetLife,

What is the difference between CS and RR isolation levels?

1 Answers

What is with ur in db2?

0 Answers

Can there be more than one cursor open for any program?

0 Answers

What is the difference between using bind () and rebind () methods of naming class?

0 Answers

What is a system catalog table in db2?

0 Answers

What is cursor with hold option in db2?

0 Answers

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers CTS, IBM,

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers JPMorgan Chase,

Is ibm db2 free?

0 Answers

Which catalog tables contain authorization information?

1 Answers

For more DB2 Interview Questions Click Here