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
Explain dclgen.
Give the name of some fields form sqlca.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Mention data types used in db2 ?
How do I delete a table in database?
What is check constraint. Explain with example.
What are host variables in db2?
What is nvl in db2?
What is the difference between nvl and coalesce?
How to find the number of rows in db2 tables?
Which is faster delete or truncate?
What are concurrency issues?
What is the difference between dbm cfg and db cfg file in db2 ?
What is the use of db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?