show connection

Shows zero or more existing connection profiles, which include the agent and the JDBC parameters.

Syntax

show connection connection_name

Parameters

connection_name – (optional) the name of the connection with wildcards. If you do not provide this parameter, all connections are shown.

Examples

Example 1 – shows all existing database connection profiles:

show connection  
go

The returned result is:

NAME  TYPE AGENT      HOST  PORT DATABASE USER DESCRIPTION
----- ---- ---------- ----- ---- -------- ---- ------------------
pdb   ASE  localagent users 5010 pdb      sa   primary database
rdb   ASE  localagent users 5010 rdb      sa   replicate database

(0 rows affected)

Example 2 – shows connection names that end with "t":
```
show connection *t
go
```