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






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 is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,


I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

0 Answers   Cap Gemini,


which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,


What is isolation level?

4 Answers  


what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,






What is a synonym? How is it used?

2 Answers  


i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Satyam, Cap Gemini, Wipro, CGI, IBM, EDS,


How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   Infosys, IBM,


Describe the elements of the SELECT query syntax?

3 Answers  


what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,


What is a subselect? Is it different from a nested select?

1 Answers  


Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  






Categories