Savepoints Within Transactions

SAP 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 the IQ main store—to less than a full transaction's worth. Setting savepoints allows you to subdivide transactions.

• Releasing a Savepoint
  Releasing a savepoint frees up the version pages that have been used up to that savepoint.
• Rollbacks to Savepoints
  A ROLLBACK TO SAVEPOINT command undoes all changes after a 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.