SET
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The SET statement specifies a runtime option for the current session. The selected option remains in effect until the session is terminated or the option is changed using another SET statement.
Note: This statement has additional considerations when used in a distributed environment. For more information, see the Star User Guide.
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.
Last modified date: 04/03/2024