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 a cics task?
what are transient data sets defined to cics?
How do you unload data from DB2 tables into a PS file.write the code and how do you do it? what will be the syntax?
what is difference between call and link ?
Explain the function of the load command?
Explain floating maps with illustration.
Can you define bms?
What are the CICS commands available for program control?
what are the reserved words for cics?
What is BMS?
What is the cics command that is used to access current date and time?
What is the CICS command that gives the length of TWA area?