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 |
Can you define multiple maps in a BMS mapset?
What is the option specified in the read operation to gain multiple concurrent operations on the same dataset?
Mention the content that is present inside a PPT ?
Explain the significance of rdo?
What is the COMMAREA(communications area)?
In CICS, BMS what is the use of FREEKB parameter
Explain how pa key is different from pf key?
What are fset, frset?
What is trigger level in the context of TDQs?
How is the stopper byte different from an auto skip byte ?
With the use of an alternate index, how is a VSAM file accessed?
Tsqs can be written in the main storage or auxiliary storage? State true or false