Creates a savepoint inside the existing transaction.
savepointname is case insensitive.
SAVEPOINT creates a point in the transaction to which all work can be rolled back to without ending the transaction. The transaction state is shared with the client, so a savepoint cannot be created in SQL if a transaction has not been started either by an Advantage client (i.e., ACE API AdsBeginTransaction) or through the Advantage SQL engine.
A savepoint is created in the current savepoint level and is only valid in the current savepoint level. See Nesting Transactions for additional information on savepoint level. If a savepoint with identical name exists in the current savepoint level, that savepoint will be destroyed and a new savepoint will be established at the current transaction location. It has no effect on other savepoints.
UPDATE sal SET salary = 35000.00 WHERE emp_id = 25089;
DELETE FROM sal WHERE salary > 36000.00;
ROLLBACK TO SAVEPOINT test;