D.3.3 Managing Transactions

In the default mode, statements are committed only when EXEC SQL COMMIT is issued. The embedded SQL interface also supports autocommit of transactions (similar to libpq behavior) via the -t command-line option to ecobpg or via the EXEC SQL SET AUTOCOMMIT TO ON statement. In autocommit mode, each command is automatically committed unless it is inside an explicit transaction block. This mode can be explicitly turned off using EXEC SQL SET AUTOCOMMIT TO OFF.

See

Refer to "ecpg" in "PostgreSQL Client Applications" in the PostgreSQL Documentation for information on -t command-line option to ecobpg.

The following transaction management commands are available:

EXEC SQL COMMIT END-EXEC: Commit an in-progress transaction.

EXEC SQL ROLLBACK END-EXEC: Roll back an in-progress transaction.

EXEC SQL SET AUTOCOMMIT TO ON END-EXEC: Enable autocommit mode.

EXEC SQL SET AUTOCOMMIT TO OFF END-EXEC: Disable autocommit mode. This is the default.