Establishing Savepoints
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
-
From the Connection window menu, select Connection / Connection Properties.
-
Select TRANSACTION_COMMITTED from the Transaction Isolation drop-down list. Do not select the Auto Commit check box.
Click Set; then, click Close.
-
From the Connection window menu, select Connection / Load and Go. The Get Load And Go SQL window appears.
-
Specify the statement that you want to execute.
Click Submit.
-
Select Connection / Set Savepoint. In the Set Savepoints window, specify a savepoint name.
Click Apply; then, click Close. The Connection window indicates whether or not the savepoint succeeded.
-
Return to the Get Load And Go SQL window and specify another statement.
Click Submit.
-
Select Connection / Rollback Savepoint. In the Rollback Savepoints window, specify the savepoint name.
Click Apply; then, click Close. The Connection window indicates whether or not the savepoint rollback succeeded.
-
Return to the Get Load And Go SQL window and specify another statement.
Click Submit; then, click Close.
The Connection window displays data that was inserted before the first Savepoint. The second insert was rolled back.
