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.
