commit
Make database changes permanent
Syntax
commit(conn)
Description
commit(conn)
makes permanent changes made to the
database connection conn
since the last commit
or
rollback
function was run. To run this
function, the AutoCommit
flag for conn
must be
off
.
Examples
Example 1 — Check the Status of the Autocommit Flag
Check that the status of the AutoCommit
flag for connection
conn
is off
.
conn.AutoCommit ans = 'off'
Example 2 — Commit Data to a Database
Insert
exdata
into the columnsDEPTNO
,DNAME
, andLOC
in the tableDEPT
, for the data sourceconn
.datainsert(conn,'DEPT',... {'DEPTNO';'DNAME';'LOC'},exdata)
Commit this data.
commit(conn)
Tips
For ODBC connections, you can use the commit
function with the
native ODBC interface. For details, see database
.