Previous Topic Next topic Print topic


AUTOCOMMIT

When set, each SQL statement is treated as a separate transaction and is committed immediately upon execution. If this is not set, and the ODBC driver you are using supports transactions, statements must be explicitly committed (or rolled back) as part of a transaction.

Syntax:

[NO]AUTOCOMMIT

Properties:

Default: NOAUTOCOMMIT

Scope:

Used at compile time: No
Behavior at run time: Process

See Scope - OpenESQL SQL Compiler Directive Options for more information.

Comments:

The SET AUTOCOMMIT embedded SQL statement overrides the AUTOCOMMIT compiler directive option.

Previous Topic Next topic Print topic