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
3202 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

how to unload different table data into different gdg files/ vsam files.

3 Answers

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers

How to view db2 table structure?

0 Answers

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers Deloitte,

How to update more then one record using update?

5 Answers IBM,

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers Accenture,

can all users have the privilage to use the sql statement select * (dml)?

0 Answers IBM,

how can we find nth max salary from A table

5 Answers IBM,

What is ibm db2 connect?

0 Answers

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