Savepoints Within Transactions

Sybase IQ supports savepoints within a transaction.

A SAVEPOINT statement defines an intermediate point during a transaction. Because a single IQ transaction may write millions of rows of data, you may want to limit the amount of data that is committed—and thus written to disk—to less than a full transaction's worth. Setting savepoints allows you to subdivide transactions.

You can undo all changes after a savepoint using a ROLLBACK TO SAVEPOINT statement.

• Release of Savepoints
  Once a RELEASE SAVEPOINT statement executes or the transaction ends, you can no longer use the savepoint.
• Rollbacks to Savepoints
  You can undo all changes after a savepoint by issuing a ROLLBACK TO SAVEPOINT.
• Automatic and User-Defined Savepoints
  IQ sets an implicit savepoint before and after every DML command.
• Named and Nested Savepoints
  Named, nested savepoints provide many active savepoints within a transaction.