Hitachi

Hitachi Advanced Database SQL Reference


5.1.1 Specification format for the COMMIT statement

The COMMIT statement validates the database contents that were updated by a transaction, and terminates the transaction normally.

Organization of this subsection

(1) Specification format

You can specify a COMMIT statement when you use the adbsql command to execute an SQL statement. You cannot specify a COMMIT statement in an application program.

The specification format of a COMMIT statement in the adbsql command is as follows:

COMMIT-statement ::= COMMIT

(2) Privileges required at execution

To execute the COMMIT statement, the CONNECT privilege is required.