Test Data Manager

  • Private Community

  • 1.  JAVELIN: How to Set Begin Transaction in DB2Activity?

    Posted Mar 01, 2017 05:20 PM

    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.



  • 2.  Re: JAVELIN: How to Set Begin Transaction in DB2Activity?
    Best Answer

    Posted Mar 02, 2017 12:17 PM

    Hi Prince, 

     

    I would suggest opening a support case for this issue. You can open a support case by going to https://support.ca.com/irj/portal/newhome or calling support at one of these numbers https://www.ca.com/us/services-support/ca-support/contact-support.html.

     

    Best regards,

    Taylor



  • 3.  Re: JAVELIN: How to Set Begin Transaction in DB2Activity?

    Broadcom Employee
    Posted Mar 02, 2017 12:37 PM

    Hi Prince,

    I agree with Taylor's assessment.  This appears to be an issue directly with the code.  By opening a Support Case, Support will be able to get a Developer involved to look at the environment and determine the best course of action.

    Cheers!
    Les