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
Answer / anonumous
it would be FETCH 300 ONLY
|Is This Answer Correct ?||0 Yes||0 No|
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What technique is used to retrieve data from more than one table in a single SQL statement?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
Where is the access path logic created by the DB2 Optimizer stored?
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 .
What is the difference between group by and order by?
How to resolve -407 sql code in DB2?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
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.
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
How is a typical DB2 batch program executed ?