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 / anonumous
it would be FETCH 300 ONLY
|Is This Answer Correct ?||0 Yes||0 No|
Explain transactions, commits and rollbacks in DB2.
How to handle null values in db2
What is the use of COMMAREA ?Minimum how much data we can pass from it?
What is a DB2 bind?
What r the comman abends in db2, jcl and cobol???????
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
what is different three logs in DB2?
What is lock contention?
How would one remove old reorg information from the DB2 catalog?
What is a collection?
What will happen, while trying to close the closed cursor.
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?