DISCONNECT

Description

Executes a COMMIT for the specified transaction object and then
disconnects from the specified database.

Syntax

DISCONNECT {USING TransactionObject};

1	DISCONNECT {USING TransactionObject};

Parameter	Description
TransactionObject	The name of the transaction object that identifies the database you want to disconnect from and in which you want to permanently update all database operations since the previous COMMIT, ROLLBACK, or CONNECT. This clause is required only for transaction objects other than the default (SQLCA).

Usage

It is good practice to test the success/failure code after
executing a DISCONNECT statement.

Examples

Example 1

This statement disconnects from the database specified in the
default transaction object:

DISCONNECT ;

1	DISCONNECT ;

Example 2

This statement disconnects from the database specified in the
transaction object named Emp_tran:

DISCONNECT USING Emp_tran ;

1	DISCONNECT USING Emp_tran ;

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2022

PB Docs 2022 Powerbuilder Documentation 2022

August 21, 2023

Was this article helpful?

Connection Information