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.
Check that the status of the AutoCommit flag for connection
conn is off.
conn.AutoCommit ans = 'off'
Insert exdata into the columns DEPTNO,
DNAME, and LOC in the table
DEPT, for the data source conn.
datainsert(conn,'DEPT',...
{'DEPTNO';'DNAME';'LOC'},exdata)
Commit this data.
commit(conn)
For ODBC connections, you can use the commit function with the
native ODBC interface. For details, see database.