Command Reference

GET CONNECTION STATE

Displays the connection state. Possible states are:

• Connectable and connected
• Connectable and unconnected
• Unconnectable and connected
• Implicitly connectable (if implicit connect is available).

For more information about these connection states, see the SQL Reference.

This command also returns information about the database connection mode (SHARE or EXCLUSIVE), and the alias and name of the database to which a connection exists (if one exists).

Authorization

None

Required Connection

None

Command Syntax

>>-GET CONNECTION STATE----------------------------------------><
 

Command Parameters

None

Examples

The following is sample output from GET CONNECTION STATE:

Database Connection State Connection state = Connectable and Connected Connection mode = SHARE Local database alias = SAMPLE Database name = SAMPLE

Usage Notes

This command does not apply to type 2 connections (see SET CLIENT).