Hi Selva & Anoop, Thank you all.
Best regards, Yuan -----Original Message----- From: Selva Govindarajan [mailto:[email protected]] Sent: Tuesday, January 23, 2018 2:16 PM To: [email protected] Subject: RE: Set autocommit to OFF in db level As per the JDBC application, the default mode is auto-commit mode. Trafodion T4 connection is also set to auto commit by default. Same is the case with ODBC specification. Trafodion ODBC driver also sets the connection to SQL_AUTOCOMMIT_DEFAULT. SQL_AUTOCOMMIT_DEFAULT is SQL_AUTOCOMMIT_ON. Selva -----Original Message----- From: Anoop Sharma [mailto:[email protected]] Sent: Monday, January 22, 2018 9:27 PM To: [email protected] Subject: RE: Set autocommit to OFF in db level 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. anoop -----Original Message----- From: Liu, Yuan (Yuan) [mailto:[email protected]] Sent: Monday, January 22, 2018 7:30 PM To: [email protected] 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 it? Best regards, Yuan
