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

  1. The DISCONNECT statement disconnects the UAP from HiRDB after HiRDB has executed the COMMIT statement. During this process, all holdable cursors are also closed.
  2. 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