Microsoft SQL Server Using CONNECT, COMMIT, DISCONNECT, and ROLLBACK – PB Docs 2019

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 SQL Server transaction. This
is the start of a logical unit of work.

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, a
COMMIT TRANSACTION executes, then a BEGIN TRANSACTION executes to
start a new logical unit of work. If AutoCommit is true, an error
occurs when a COMMIT executes.

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, an error occurs when a
ROLLBACK executes.