Database Toolbox™

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)
   

See Also

database, exec, fastinsert, get, rollback, update

columns

confds