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.
Pinned topic Autocommit in Optim Development Studio
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-10-05T21:18:12Z at 2011-10-05T21:18:12Z by rpeterson
rpeterson 270004E64D2 Posts
Re: Autocommit in Optim Development Studio2011-10-05T21:18:12ZThis is the accepted answer. This is the accepted answer.There currently isn't a method to turn off AutoCommit from within Data
Studio. This feature has been requested in the past however and
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