There used to be an “auto commit” or “immediately commit” type of option in the preferences. I think that I was on Sql Nav 5.5 or some version close to that. Anyway, I had the preferences set up to where there was NEVER a commit unless I explicitly ran the command myself.
For version 6.2, can I set it up to work this way? Does ver 6.2 auto commit for any updates, inserts, etc or do I have to explicitly issue the command myself?
Or if I run an UPDATE statement or INSERT or DELETE, will it be automatically COMMITED?
The help in version 6.2 states “Note that there is a global preference available to automatically commit every DML statement. This preference is found in the Preferences dialog under the Session group.”
I do not see such an option when I look in preferences.