MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur télécharger 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)

Pas de commentaire

MATLAB DATABASE TOOLBOX RELEASE NOTES Guide de l'utilisateur Page 457