odbcSetAutoCommit {RODBC} | R Documentation |
Set ODBC database connection's auto-commit mode.
odbcSetAutoCommit(channel, autoCommit=TRUE)
channel |
RODBC connection object returned by odbcConnect . |
autoCommit |
logical. Set auto-commit on? |
Auto-commit is a concept supported only by ODBC connections to transactional DBMSs.
If a connection to a transactional DBMS is in auto-commit mode (the
default), then all its SQL statements will be executed and committed
as individual transactions. Otherwise, its SQL statements are grouped
into transactions that are terminated by an execution of commit
or rollback
.
By default, new connections are in auto-commit mode. If auto-commit
mode has been disabled, an SQL commit
statement must be
executed in order to commit changes; otherwise, pending database
changes will not be saved.
odbcSetAutoCommit
stops if channel
is an invalid
connection. The function returns (-1) on error, (0) on success and (1)
on success with a message that would be returned by
odbcGetErrMsg
.
Norman Yamada, Yasser El-Zein