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

first when i try to write a record into the file, wresp=duprec, but follwed with that if i try to read the record it say record not fnd.. actually the record is not written in the file, but it says that duprec when trying to write... why this happens, pls help me asap..!

1 Answers   CGI, Love, TechRel,


How do you fire a batch job from a CICS transaction ?

2 Answers   TCS,


What is the most common way of building queue-id of a TSQ? (Name the constituents of the Queue ID).

2 Answers  


What is meant by PPT and what are its uses?

0 Answers  


which cics command must be issued by the application program in order to gain access to the common work area (cwa)?

0 Answers   IBM,






How do you use altindxs in batch, cics programs?

0 Answers  


How do you access storage outside your CICS program?

2 Answers   IBM,


why we code ACCUM parameter in cics send time

1 Answers  


What does a cics translator do?

0 Answers  


Can you use occurs in bms map?

0 Answers  


What is the term conversational programs means?

0 Answers  


How do you access the records randomly in TSQ ?

2 Answers   IBM,


Categories