MATLAB DATABASE TOOLBOX RELEASE NOTES User's Guide download pdf (Page 457)

Make database changes permanent

commit(conn)

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.

Example 1 — Check the Status of the Autocommit Flag

Check that the status of the AutoCommit flag for connection conn is off.

get(conn,'AutoCommit')

Example 2 — Commit Data to a Database

Insert exdata into the columns DEPTNO, DNAME, and LOC in the table DEPT, for the

data source conn.

fastinsert(conn, 'DEPT', {'DEPTNO';'DNAME';'LOC'},...

Commit this data.

commit(conn)

MATLAB DATABASE TOOLBOX RELEASE NOTES User's Guide Page 457