trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anoop Sharma <>
Subject RE: Set autocommit to OFF in db level
Date Tue, 23 Jan 2018 05:26:39 GMT
hi, set transaction statements are runtime stmts and only impact that session
when issued.
They are not like a cqd (control query default) that could be set at system level.

By default, autocommit is OFF. But sqlci and trafci set it to ON at startup by
internally issuing 'set transaction autocommit on'. This is done so interactive
statements could be treated as standalone stmts and would commit any transaction
started for them.
If a user specified transaction is being used by issuing 'begin work', then autocommit
will be OFF.

>From an application program, autocommit will be OFF by default. 

Am not sure if there is a connectivity/client property that could be set to turn autocommit
ON or OFF.
Someone familiar with connectivity can answer that.


-----Original Message-----
From: Liu, Yuan (Yuan) [] 
Sent: Monday, January 22, 2018 7:30 PM
Subject: Set autocommit to OFF in db level

Hi Trafodioneers,

As I know we can use "set transaction autocommit off" in session level in Trafodion.
Do we have an approach to set autocommit to off in database level, if yes, how to realize

Best regards,

View raw message