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
3149 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 do you mean by NOT NULL? When will you use it?

3 Answers

Who uses db2?

0 Answers

What is image copy in db2?

0 Answers

How does DB2 use multiple table indexes?

1 Answers

what is dynamic cursor?gives syntax for this?

1 Answers TCS,

What is difference between isnull and coalesce?

0 Answers

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers

What is the syntax required for the creation of a cursor?

1 Answers

When would you prefer to use VARCHAR?

3 Answers

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers MCN Solutions,

What is a DB2 catalog?

2 Answers

what is the difference between normal select query and currosor

2 Answers Cap Gemini, TCS,

For more DB2 Interview Questions Click Here