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
Give the name of some fields form sqlca.
What is database alias db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is dbrm in db2 database?
Name the lockable units in DB2?
Which component is responsible for processing sql statements and selecting access paths?
Mention the location where the output received from explain statement is stored.
Is ibm db2 free?
Can we update view in db2?
What is the physical storage length of the data types date, time, and timestamp?
What db2 400?
What is cursor stability in db2?
Are views updateable?
How to run db2 command in windows?
What is bind and rebind in db2?