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 buffer pool?
What is universal database?
What is null value in db2?
Is db2 free?
Why select is not preferred in embedded sql programs?
How to access db2 tables in mainframe?
What is bind plan?
How can you quickly find out the # of rows updated after an update statement?
What is the maximum length of sqlca?
What is db2 bind?
What is cloudant database?
What is sqlca?
What is package in db2 mainframe?
What is a dbrm in db2?
What is cascading rollback?