Topic
  • 1 reply
  • Latest Post - ‏2011-10-05T21:18:12Z by rpeterson
rpeterson
rpeterson
2 Posts

Pinned topic Autocommit in Optim Development Studio

‏2011-10-05T14:50:11Z |
Is there a way to turn off the autocommit in Optim?

I've tried: Window->preferences->Data Mangement->SQL Development->Routines->Process and unchecking the box 'Commit changes to the database after running', but that does not seem to stop the autocommit.

Any thoughts?
Updated on 2011-10-05T21:18:12Z at 2011-10-05T21:18:12Z by rpeterson
  • rpeterson
    rpeterson
    2 Posts

    Re: Autocommit in Optim Development Studio

    ‏2011-10-05T21:18:12Z  
    There currently isn't a method to turn off AutoCommit from within Data
    Studio. This feature has been requested in the past however and
    development has
    plans for it to be in the 4th Quarter release of Data Studio. If you have
    questions on it in the future you can reference RIMS requirement
    R2PRO00004886 - Add ability to turn autocommit on or off when executing
    SQL Scripts.