Disconnecting from the database

When your database processing is completed, you disconnect
from the database using the SQL DISCONNECT statement:

DISCONNECT;

1	DISCONNECT;

If you are using a Transaction object other than SQLCA, you must include
the USING TransactionObject clause in the SQL syntax:

DISCONNECT USING <span>TransactionObject</span>;

1	DISCONNECT USING <span>TransactionObject</span>;

For example:

DISCONNECT USING ASETrans;

1	DISCONNECT USING ASETrans;

Automatic COMMIT when disconnected

When a transaction is disconnected, PowerBuilder issues a COMMIT statement by
default.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 12.5

August 9, 2023

Was this article helpful?