AnsweredAssumed Answered

JAVELIN: How to Set Begin Transaction in DB2Activity?

Question asked by prince.munjal on Mar 1, 2017
Latest reply on Mar 2, 2017 by dovle01

Hi Team

 

In a single DB2 Execute Query, I have couple of updates that should be execute as a single transaction scope. If any execution failure, data should not commit.

 

But when i tried passing below query to DB2 activity:

"Update <table> set Col=<new value> where  Col=<old Value>; Rollback;"

 

DB Connection still commits data with new value

 

Please advise.

Outcomes