5.2.1 Specification format for the ROLLBACK statement
The ROLLBACK statement invalidates the database contents that were updated by a transaction, and cancels the transaction.
- Organization of this subsection
(1) Specification format
You can specify a ROLLBACK statement when you use the adbsql command to execute an SQL statement. You cannot specify a ROLLBACK statement in an application program.
The specification format of a ROLLBACK statement in the adbsql command is as follows:
ROLLBACK-statement ::= ROLLBACK
(2) Privileges required at execution
To execute the ROLLBACK statement, the CONNECT privilege is required.