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

Which catalog table stores referential constraints?

1 Answers

What techniques will be used to avoid deadlock??

5 Answers IBM, SUN,

What is the maximum length of sqlca?

0 Answers

Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers

How to compare data between two tables in db2?

0 Answers

Why db2 is called db2?

0 Answers

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers Emsang,

i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers EDS,

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers

What is reorg in database?

1 Answers

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers MCN Solutions,

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers

For more DB2 Interview Questions Click Here