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|
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
what is consistency token
Normalization in DB2 – first normal form, second normal form
what is rebinding ?
How does DB2 determine what lock-size to use?
what is diffrence b/w file-aid tool and file-aid utility???
How are write I/Os from the buffer pool executed?
Explain transactions, commits and rollbacks in DB2.
What is a clustering index?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?