Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 3269 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / anonumous
it would be FETCH 300 ONLY
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to retrieve rows from a db2 table in embedded sql?
How do I add a column to a table in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
Explain the contention situations caused by locks?
What is declare cursor?
What is the physical storage length of timestamp data type?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Which components manage deadlocks in db2?
Mention some fields that are a part of sqlca.
Define predicate?
What are the contents of dclgen?
Which component is used to execute the sql statements?
What is the difference between nvl and coalesce?
How to restart a DB2 program?
What action db2 takes when a program aborts in the middle of a transaction?
