Interested to Buy Any Domain ? << Click Here >> for more details...
If the main program has only cobol statements and subprogram
has the db2 statements what is the procedure for
precompilation. for which program we need to do the
precompilation
- 1 Answers
- 6694 Views
- IBM, I also Faced
- E-Mail Answers
How does a cursor work?
what is utility for parm lib
What is isolation level?
How can we read records for specific member in CL? AND rpg?
What is PRIME TABLE and what are the uses of it
What do you mean by storage group (stogroup)?
What is reorg and runstats in db2?
How many buffer pools are available in db2?
Which isolation level provides maximum concurrency?
What is cascading rollback?
What is the difference between primary key & unique index ?
In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)
COBOL 
