Can you issue SQL COMMIT from a CICS program?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how do you terminate an already issued delay command?

752


What are the cics tables?

849


Define task work area?

1089


What are the types of processes to create a map in cics?

814


explain the means of supporting pseudo conversation programming. (Eg. Storing and restoring of states, control flow, error handling)?

838


In case if the user inputs the characters which turn out to be uppercase, then what is the procedure to close that condition?

767


Explain cedf transaction commands?

855


Sync points cannot be requested by the application programs? State true or false

904


Explain cemt transaction commands?

820


Explain the difference between temporary storage queue (tsq) and transient data quene (tdq)?

721


List out all the tables that are a part of cics ?

749


What is the term conversational programs means?

761


Highlight the difference between a symbolic map and physical map?

810


What do you mean by CEMT?

993


Explain the difference between intra partition tdq and extra partition tdq?

802