Can you issue SQL COMMIT from a CICS program?

Answers were Sorted based on User's Feedback



Can you issue SQL COMMIT from a CICS program?..

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

Can you issue SQL COMMIT from a CICS program?..

Answer / ezhil_18

Yes,We can also call this process(SYNCPOINT) as Two phase
commit.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More CICS Interview Questions

Can you define commarea?

0 Answers  


Explain how do you access storage outside your cics program?

0 Answers  


What is the meaning of the SYNCPOINT command?

1 Answers   IBM,


What will happen if some program tries to process a queue on which an ENQ command has been issued by some other program?

0 Answers   Accenture,


What is the difference between link xctl?

8 Answers   IBM, MBNA,






Can you define multiple maps in a BMS mapset?How,can anybody sent with syntax?

3 Answers  


What is the difference between CICS Program Control Table (PCT) and CICS Processing Program Table (PPT) ?

4 Answers   IBM,


Explain how would you resolve an asra abend?

0 Answers  


What are the recoverable cics resources?

0 Answers  


When you compile a CICS program, the (pre)compiler puts an extra chunk of code. Where does it get stored

1 Answers  


what is the differences between getting the system time with eibtime and asktime command?

0 Answers   IBM,


What are all things you can do with CEDA?

2 Answers   IBM,


Categories