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.