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.