CONNECT

Establishes the database connection.
After you assign values to the required properties of the transaction
object, you can execute a CONNECT. After the CONNECT completes successfully, PowerBuilder
automatically starts a transaction. This is the start of a logical
unit of work.

If AutoCommit is true, PowerBuilder does not start a transaction.

COMMIT

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.

If AutoCommit is false (the default), a COMMIT TRANSACTION
executes, then a BEGIN TRANSACTION executes to start a new logical
unit of work.

If AutoCommit is true, the COMMIT is issued but has no effect because
all previous database changes were already automatically committed.

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.

If AutoCommit is false, a COMMIT TRANSACTION executes automatically
to guarantee that all changes made to the database since the beginning
of the current logical unit of work are committed.

ROLLBACK

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.

If AutoCommit is false, a ROLLBACK TRANSACTION executes, then
a BEGIN TRANSACTION executes to start a new logical unit of work.

If AutoCommit is true, a ROLLBACK TRAN executes but has no
effect because all previous database changes were already committed.