it would be FETCH 300 ONLY

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 / anonumous

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

Answer Posted / anonumous

it would be FETCH 300 ONLY

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is db2 stogroup?

1129

How do you pull up a query which was previously saved in qmf?

1116

What is concurrency?

1177

What is ibm db2 connect?

957

What is the purpose of using commit?

1054

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1697

How do I import a csv file into db2?

955

What are concurrency issues?

1054

Is db2 a database?

938

What is db2 optimizer?

1204

What does sqlcabc has?

1016

What is the difference between nvl and coalesce?

1030

What is db2 command?

994

What is a cursor in programming?

1028

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

1070