This is machine translation
Translated by 
Mouseover text to see original. Click the button below to return to the English version of the page.
Note: This page has been translated by MathWorks. Click here to see
To view all translated materials including this page, select Country from the country navigator on the bottom of this page.
To view all translated materials including this page, select Country from the country navigator on the bottom of this page.
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
exdatainto the columnsDEPTNO,DNAME, andLOCin 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.
