3.3.64 SAVEPOINT

Table of Contents Previous Next


3 The SQL Language : 3.3 SQL Commands : 3.3.64 SAVEPOINT

3.3.64 SAVEPOINT
SAVEPOINT -- define a new savepoint within the current transaction
SAVEPOINT savepoint_name
SAVEPOINT establishes a new savepoint within the current transaction.
Use ROLLBACK TO SAVEPOINT to roll back to a savepoint.
SAVEPOINT is not supported within SPL programs.
The above transaction will commit a row into the dept table, but the inserts into the emp and jobhist tables are rolled back.

3 The SQL Language : 3.3 SQL Commands : 3.3.64 SAVEPOINT

Table of Contents Previous Next