User`s guide

commit
7-27
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.
get(conn,'AutoCommit')
ans =
off
Example 2 — Commit Data to a Database
1
Insert exdata into the columns DEPTNO, DNAME, and LOC in the table DEPT, for the
data source conn.
fastinsert(conn, 'DEPT', {'DEPTNO';'DNAME';'LOC'},...
exdata)
2
Commit this data.
commit(conn)