Does WinSQL support transaction and how do they work?
When Auto commit is ON, all the transactions are automatically committed unless they were started manually. For example in Sybase or MS SQL Server you can send a ‘begin tran’ command to manually start a transaction. Statements within this kind of transaction are only committed or rollbacked when the user explicitly issues the appropriate command. However, some databases like Oracle and DB2 does not allow this kind of transactions. Therefore, you need to turn the Auto Commit option to OFF in order to rollback or commit a unit of work. You can turn Auto Commit OFF at the login screen. Click the “Options” button if the connection options are not visible. Note: When Auto Commit is OFF, a red indicator appear on the status bar. This acts as a reminder for the user to issue a commit statement at the end.
