Savepoints

To limit the amount of data that Sybase IQ writes to disk, set a savepoint. Savepoints define a point in a transaction after which all changes can be undone by a ROLLBACK TO SAVEPOINT statement. This allows you to commit data before the entire transaction finishes.

• Testing Data Consistency
  This example shows you how to test for data consistency.
• Setting Savepoints
  You can identify important states within a transaction and return to them selectively by using savepoints to separate groups of related statements.