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

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,


what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,


What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, TCS,


What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  


Where is the access path logic created by the DB2 Optimizer stored?

1 Answers  






SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,


What is the difference between group by and order by?

2 Answers   IBM, TCS,


How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,


Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,


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.

0 Answers  


Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  


How is a typical DB2 batch program executed ?

1 Answers  






Categories