Cancels all database operations in the specified database since the last COMMIT, ROLLBACK, or CONNECT.
Using COMMIT and ROLLBACK in
a server component
COMMIT and ROLLBACK commands
embedded in a server component might have different effects depending
on the setting of the UseContextObject DBParm parameter.
For information on the UseContextObject parameter see Connecting to Your Database. For information on deploying components to a transaction server, see Application Techniques.
ROLLBACK {USING TransactionObject} ;
Parameter |
Description |
|---|---|
TransactionObject |
The name of the transaction object that identifies the database in which you want to cancel all operations since the last COMMIT, ROLLBACK, or CONNECT. This clause is required only for transaction objects other than the default (SQLCA). |
ROLLBACK does not cause a disconnect, but it does close all open cursors and procedures.
Error handling
It is good practice to test the success/failure code
after executing a ROLLBACK statement.
Example 1 This statement cancels all database operations in the database specified in the default transaction object:
ROLLBACK ;
Example 2 This statement cancels all database operations in the database specified in the transaction object named Emp_tran:
ROLLBACK USING emp_tran ;
