ODBCLINK/SE Reference Manual (36217-90410)

Application Development ODBCLink/SE Reference Manual

ODBCLink/SE

Turning AutoCommit On/Off

AutoCommit “on” is the default value for all ODBC drivers. Turning AutoCommit on/off is normally accomplished

by the application calling SQLSetConnectOption. The AutoCommit on/off setting in ODBC Administrator is there

for historical reasons only and should not be used. Setting AutoCommit “off:” in the ODBC Administrator is not a

good idea as the application can get confused. For instance, it can incorrectly assume that AutoCommit is on, and

then emit SQL that never gets committed.