Hitachi

Hitachi Advanced Database SQL Reference


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.