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 |
Hai I have a VSAM file and there are two CICS pgms A and B both intends to update the file. How to code the program so that it does not under go a dead lock situation.
What will happen if some program tries to process a queue on which an ENQ command has been issued by some other program?
Kindly specify the pic clause for the data type of length option field type of data fields?
What is the function of the Terminal Control Table(TCT)?
How do u know if a start command intiated a transaction or a terminal intiated a transaction
Explain the difference between temporary storage queue (tsq) and transient data quene (tdq)?
Which of the following commands, when issued by 2 different programs running at the same time, will prevent simultaneous use of resource 'SINGLE'?
List the sequence of steps used to achieve ?Modification in Skip Sequential Mode.?
How To Compile The COBOL-BD2-CI CS Programs In Real TIme? Please Give Me the Detailed Description?
What is the difference between a Symbolic map and Physical map ?
what are the commands used to gain exclusive control over a resource?
what are the differences between temporary storage queue (tsq) and transient data quene (tdq)?