The begin transaction and commit transaction commands tell Adaptive Server 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. You define a savepoint inside a transaction using save transaction.
Transactions give you control over transaction management. In addition to grouping SQL statements to behave as a single unit, they 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.
The following sections discuss general transaction topics and transaction commands, with examples.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
