Displays the connection state. Possible states are:
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).