SET AUTOCOMMIT

Function

Sets the autocommit behavior of the current database session. By default, embedded SQL programs do not automatically commit, so you need to explicitly issue COMMIT. This command can change the session to the automatic commit mode so that each individual statement is implicitly committed.

Syntax

SET AUTOCOMMIT { = | TO } { ON | OFF }