DISCONNECT statement (Disconnect a UAP from HiRDB)

Scalable Database Server, HiRDB Version 8 SQL Reference

DISCONNECT statement (Disconnect a UAP from HiRDB)

Function

The DISCONNECT statement terminates the current transaction normally, sets synchronization points, generates one unit of commitment, and disconnects the UAP from HiRDB.

Privileges

None.

Format

DISCONNECT

Common rules

The DISCONNECT statement disconnects the UAP from HiRDB after HiRDB has executed the COMMIT statement. During this process, all holdable cursors are also closed. If the UAP is connected to a distributed RD-node, it is also disconnected from the distributed RD-node at the same time.
If the UAP terminates before the DISCONNECT statement is executed, the DISCONNECT statement (in the case of normal termination) is assumed after HiRDB executes the ROLLBACK statement.

Note

The DISCONNECT statement cannot be specified from an X/Open-compliant UAP running under OLTP.

Example

Disconnect a UAP from HiRDB:

DISCONNECT