CICS / DB2 PGM A links to CICS / DB2 PGM B... table1 is updated successfully in PGM B and table 2 update fails in WHEN OTHER condition in PGM B. Here we load err msg in commarea and execute CICS RETURN to go to PGM A. In this situation whether table1 update will be commited or not?
Assumption: both the program plan are not common. They have separate plans.
Please provide me an answer on whether the COMMIT will happen for table 1 update.
OK, what bit of the manual did you NOT understand with regards to COMMIT?
I do understand the concept of COMMIT and Syncpoint. The case I was explaining doesnt have them. I wanted to know how this kind of situation is handled, as my porject program has this kind of coding.
I got to know that the task number is assigned by CICS for the main program and till that task is completed, the commit will NOT be peformed though there were intermediate CICS RETURN stmts. CICS RETURN stmt should return the control to CICS to get the changes COMMITted. If the control is transferred to calling pgm, the COMMIT WILL NOT OCCUR.