ODBC Using CONNECT, DISCONNECT, COMMIT, and ROLLBACK – PB Docs 2021

The following table lists each transaction management statement and
describes how it works when you use the ODBC interface to connect to a
database:

Statement	Description
CONNECT	Establishes the database connection. After you assign values to the required properties of the transaction object, you can execute a CONNECT. When you connect to the database, the DBMS name returned by the ODBC SQLGetInfo call is returned in the transaction object property SQLReturnData.
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.

See also

ODBC Performance and
locking

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2021

PB Docs 2021 Powerbuilder Documentation 2021

August 21, 2023

Was this article helpful?

Connection Information