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 to be shown. 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)