Oracle Using CONNECT, DISCONNECT, COMMIT, 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 an Oracle transaction. This is
the start of a 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.

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.

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.