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
wht r the requirements for writing a cobol-db2 pgm ?
How does DB2 determine what lock-size to use?
Is ibm db2 free?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
What else is there in the PLAN apart from the access path?
How Plan is created while executing the query using SPUFI?
What is the purpose of the DSNC transaction ?
What is the purpose of rollback and commit?
How do you stop a db2 database in linux?
What is cursor?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What is the difference between using bind () and rebind () methods of naming class?