MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka stáhnout pdf (Strana 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)

Žádné komentáře

MATLAB DATABASE TOOLBOX RELEASE NOTES Uživatelská příručka Strana 457