>>--EXEC SQL--SET AUTOCOMMIT---.-ON--.---END-EXEC--><
+-OFF-+
| ON | Changes to AUTOCOMMIT mode, whereby each SQL statement is treated as a separate transaction and is committed immediately upon execution. |
| OFF | Switches off AUTOCOMMIT mode. If the ODBC driver you are using supports transactions, statements must be explicitly committed (or rolled back) as part of a transaction. |
EXEC SQL SET AUTOCOMMIT ON END-EXEC
Comments:
The SET AUTOCOMMIT statement is useful for data sources which can only execute DDL statements, such as CREATE and DROP, in AUTOCOMMIT mode.
When set to ON, AUTOCOMMIT releases locks when an outermost stored procedure executes a COMMIT or a ROLLBACK statement.
This statement overrides the AUTOCOMMIT SQL compiler directive option.