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 Posted / anonumous
it would be FETCH 300 ONLY
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between alias and synonym in db2?
Which is faster delete or truncate?
What is the physical storage length of timestamp data type?
What is host variable in db2 cobol?
Explain the contention situations caused by locks?
What is the cobol picture clause of the db2 data types date, time, timestamp?
what is utility for parm lib
What is the use of reorg in db2?
What is dclgen (declaration generator)?
Why cursor is used in db2?
Comment whether the cursor is closed during commit or not.
How do I import a csv file into db2?
What is db2 command?
How to create backup table in db2?
What are the prerogatives?