SHOW CONNECTION

Core command SH CO SHCO

Shows the details of a connection: name, type, URL, user, Database Group and Environment.

Syntax

SHOW CONNECTION [<connection>]

Arguments

Argument	Required	Values	Default
`<connection>`	No	A connection ID of the CDF	The current connection

Examples

SHOW CONNECTION db01;
SHOW CONNECTION;

Example session

WORLD-QA> SHOW CONNECTION;
CONNECTION: WORLD-QA
NAME      : Sample World Database, QA
TYPE      : H2
URL       : jdbc:h2:./samples/WorldDB_QA
USER      : sa
DATABASE GROUP : WORLDAPP
ENVIRONMENT    : QA

Illustrative output: the values come from the WORLD sample and the practice connections of the how-to on QA and production copies of WORLD, and the layout from this release; it was not captured from a BroadSQL run, and your timings will differ.

Details

The command shows the connection's name, type, URL, user, Database Group and Environment; the password is never shown. Without a connection ID, it shows the current connection. A warning is shown when the connection does not exist in the CDF, or is inactive.

Last modified in release 5.5.0.

Found something wrong or unclear on this page? Tell us, with the page address.