Cancels all database operations in the specified database since the last COMMIT, ROLLBACK, or CONNECT.
Using COMMIT and ROLLBACK in
a server component
Server component connections are not supported in PocketBuilder.
For information on COMMIT and ROLLBACK commands
embedded in a server component, see Connecting to Your
Database and Application Techniques in the
PowerBuilder documentation set.
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 ;
