DB2 Rollback

jdelmar · #1 (**permalink**) 04-23-10, 18:50

Is it possible to do a Rollback in a program CICS DB2 ??

Regards

Jorge

dav1mo · #2 (**permalink**) 04-23-10, 22:18

yes it is. do it all the time. you even wrote the correct syntax in other thread that you tried to hijack.
Dave

Marcus_A · #3 (**permalink**) 04-24-10, 23:59

Maybe I gave the wrong answer in the other thread [quoted below]. Back in the days when I used DB2 and CICS together, this is how we had to do it:

Quote:

Normally, when using CICS and DB2, there is a two-phase commit and CICS is the coordinator. Therefor SQL Commits and Rollbacks are not allowed.

Instead, execute a CICS SYNCPOINT ROLLBACK command and it will rollback any uncommitted SQL.

Internet Services

Web Development

Digital Marketing

Consumer Tech