OLE DB Using CONNECT, DISCONNECT, COMMIT, 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,
by default PowerBuilder automatically starts a transaction. Set
SQLCA.AutoCommit=TRUE to tell PowerBuilder not to start a
transaction automatically.

DISCONNECT

Terminates a successful connection. When a DISCONNECT
is executed, PowerBuilder internally executes a COMMIT WORK
statement to commit all changes and then issues a CLOSE DATABASE
statement to terminate the logical unit of work.

COMMIT

Applies all changes made to the database since the
beginning of the current unit of work.

ROLLBACK

Undoes all changes made to the database since the
beginning of the current logical unit of work.