Informix using CONNECT, COMMIT, DISCONNECT, and ROLLBACK

This table lists each transaction management statement and describes how it works when you use the Informix IN9 interface to connect to a database:

Statement

Description

CONNECT

Establishes the database connection. After you assign values to the required properties of the transaction object, you can execute a CONNECT. After this call completes successfully, PowerBuilder issues a BEGIN WORK to start a logical unit of work for the transaction.

COMMIT

Terminates the logical unit of work, guarantees that all changes made to the database since the beginning of the current unit of work become permanent, and starts a new logical unit of work.

DISCONNECT

Terminates a successful connection. DISCONNECT automatically executes a COMMIT to guarantee that all changes made to the database since the beginning of the current unit of work are committed.

ROLLBACK

Terminates a logical unit of work, undoes all changes made to the database since the beginning of the logical unit of work, and starts a new logical unit of work.


See also

Informix performance and locking