Interested to Buy Any Domain ? << Click Here >> for more details...
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).
- 1 Answers
- 6699 Views
- I also Faced
- E-Mail Answers
Answer / akbar.
SYNCPOINT ROLLBACK will rollback to the last COMMIT point
that has been made after any update in the same task.
Having said that, if PGMA and/or PGMC, in this case have
updated the database, has/have used COMMIT after their
respective updates, then ROLLBACK of PGMB after abend would
return to the very recent COMMIT made by either of the two
programs PGMA or PGMC.
| Is This Answer Correct ? | 3 Yes | 1 No |
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
What is db2 purescale?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
What can the SET option of the Repair Utility accomplish?
What is release/acquire in bind?
What keyword does an SQL SELECT statement use for a string search?
How to handle null values in db2
I use CS and update a page. Will the lock be released after I am done with that page?
How do you run JCL in cobol program
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
What is isolation level?
COBOL 
