Transaction Usage

The begin transaction and commit transaction commands tell SAP ASE to process any number of individual commands as a single unit. rollback transaction undoes the transaction, either back to its beginning, or back to a savepoint. Use save transaction to define a savepoint inside a transaction.

In addition to grouping SQL statements to behave as a single unit, transactions improve performance, since system overhead is incurred once per transaction, rather than once for each individual command.

Any user can define a transaction. No permission is required for any of the transaction commands.