Can you issue SQL COMMIT from a CICS program?
Answers were Sorted based on User's Feedback
Answer / murugan
We can not issue COMMIT on CICS Program.
There is Master-Slave Relationship between CICS Tran and
DB2 Program I mean DB2 Plan.
If you want to commit, Use CICS CMD SYNCPOINT on CICS Side.
It will commit as weel as Tran ( CICS SIDE ), Commits on
DB2 Side and Saves on the VSAMS and any other files also.
If you are asking Is it possible to USE COMMIT on CICS,
Then Ur tran will get ABEND as for as I know...
Better Luck!!
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ezhil_18
Yes,We can also call this process(SYNCPOINT) as Two phase
commit.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is DFHBMSCA?
Mention the option used in a cics command to retrieve the response code after execution of the command?
Mention one alternative aspect of CICS?
How To Set MDT(Modified Data Tag) Thru Application Program? (Dynamically)?
Explain the difference between a physical bms mapset and a logical bms mapset?
What is the eib?
WHAT ARE THE VERBS IN CICS EQUAL TO ACCEPT,DISPLAY,VALUE?
How and where is the TWA size set? .
What is task control and what are the CICS commands associated with it?
If I create a TSQ from one transaction, can I read it from another transaction?
Name some of the common tables in CICS and their usage.
What are the attribute values of Skipper and Stopper fields?