Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ Application Development Guide/ ECPG-based Development/ Running SQL Commands/ Embedded SQL Commands/ SET AUTOCOMMIT
Updated on 2024-06-03 GMT+08:00
View PDF
Share

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 }
Parent topic: Embedded SQL Commands