On this page

SHOW GROUP

Core command SHOW ENVIRONMENTS SH ENV SHENV SHOW ENVTS

Lists the connections of a connection's Database Group, with their Environments.

Syntax

SHOW GROUP [<connection> [<environment>]]

Arguments

Argument	Required	Values	Default
`<connection>`	No	A connection ID; its Database Group is listed	The current connection
`<environment>`	No. Only after `<connection>`.	An Environment, matched exactly, ignoring case	Every Environment

Examples

SHOW GROUP;
SHOW GROUP db01;
SHOW GROUP db01 QA;

Example session

WORLD-QA> SHOW GROUP;
List of environments for Database Group 'WORLDAPP':
|------------|---------------|--------------------|---------------------------------------------|---------------|
|ENVIRONMENT |ID             |USER                |NAME                                         |TYPE           |
|------------|---------------|--------------------|---------------------------------------------|---------------|
|IN          |WORLD-IN       |                    |Sample World Database, integration           |H2             |
|PROD        |WORLD          |                    |Sample World Database                        |H2             |
|QA          |WORLD-QA       |                    |Sample World Database, QA                    |H2             |
|------------|---------------|--------------------|---------------------------------------------|---------------|

3 database connections found

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

What is listed

The Database Group of the connection (the current one by default) is looked up, then every connection of the CDF in that Database Group is listed, one row per connection (Environment, ID, user, name, type), followed by the number found. The Environment filter keeps the connections whose Environment matches it exactly, ignoring case.

A warning is shown instead when the connection does not exist, is inactive, or has no Database Group.

Older names

SHOW ENVIRONMENTS, SH ENV, SHENV and SHOW ENVTS still run this command. Do not confuse SHOW ENVIRONMENTS with SHOW ALL ENVIRONMENTS, which lists every Environment of the CDF.

ENV, switch to another Environment
SHOW ALL GROUPS
SHOW ALL ENVIRONMENTS
Connections

Used in these how-tos

Last modified in release 5.5.0.

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