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
3271 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 see the structure of db2 table??

4 Answers IBM,

what is the input to PLAN? what is the input to DBRM?

4 Answers

What are concurrency issues?

0 Answers

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

5 Answers Syntel,

How Plan is created while executing the query using SPUFI?

3 Answers

What is a trigger in the db2 database?

0 Answers

What is the picture clause of null indicator variable?

0 Answers

Can we delete records from view?

0 Answers

What is a db2 tablespace?

0 Answers

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers

What is UNION,UNION ALL?

2 Answers

How does one remove entries from the SCT02 table?

1 Answers

For more DB2 Interview Questions Click Here