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
How do I delete a table in db2?
What is a collection in db2?
What do you mean by commit and rollback?
How many types of page locks can be held in db2?
How does cobol compile db2 program?
What is precompiler in db2?
Explain package in db2 and its advantages?
What db2 400?
Which are the db2 tools to protect integrity of the database?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What are db2 tables?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Is ibm db2 open source?
What is null indicator in cobol db2?
Can there be more than one cursor open for any program?