2.3.70 SAVEPOINT

Table of Contents Previous Next


2 The SQL Language : 2.3 SQL Commands : 2.3.70 SAVEPOINT

2.3.70 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.

2 The SQL Language : 2.3 SQL Commands : 2.3.70 SAVEPOINT

Table of Contents Previous Next