8. OpenSQL Statements : SET : Syntax
 
Share this page                  
Syntax
The SET statement has the following format:
[EXEC SQL] SET AUTOCOMMIT ON|OFF
AUTOCOMMIT ON
Causes an implicit commit to occur after every successfully executed query.
AUTOCOMMIT OFF
Causes an explicit COMMIT statement to be required to commit a transaction.
Default: AUTOCOMMIT OFF
The SET AUTOCOMMIT statement cannot be issued within a transaction. For a description of OpenSQL transaction behavior, see the chapter "OpenSQL Features.”
Note:  For additional SET option support for your particular gateway, see the Enterprise Access or EDBC documentation.