SAP Adaptive Server Enterprise Using CONNECT, COMMIT, DISCONNECT, and ROLLBACK – PB Docs 2021

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.