MATLAB DATABASE TOOLBOX RELEASE NOTES Guía de usuario descargar pdf (Pagina 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)

Sin comentarios

MATLAB DATABASE TOOLBOX RELEASE NOTES Guía de usuario Pagina 457