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 explain dfheiblk?

0 Answers  


What is the meaning of BMS length of field = 0?

1 Answers   IBM,


How can you use dynamic calls in cics?

0 Answers  


Can you access QSAM (seq ) files from CICS ?

2 Answers   IBM,


plz give the syntax for receive map and receive text cmds in cics

1 Answers  


How do you set the MDT option to ?ON? status, even if data is not entered?

1 Answers  


Explain what is a cursor in cics sql processing?

0 Answers  


How errors are handled in CICS programs?

0 Answers  


Which of the following are recoverable CICS resources?

1 Answers   IBM,


Specify CICS transaction initiation process. (From the perspective of CICS control programs and control tables.)

2 Answers   IBM,


Thru web page we have triggered the transaction, how can we come to know that whether it has hit the mianframes or not?

2 Answers  


What is eib?

0 Answers  


Categories