On this page

SHOW ENVIRONMENTS

Core command SHOW ENV SHOW ENVIRONMENT SHOW GROUP SH ENV SHENV SHOW ENVTS

Lists the Environments of a connection's Database Group, with the connection each one maps to.

Syntax

SHOW ENVIRONMENTS [<connection> [<environment>]]

Arguments

ArgumentRequiredValuesDefault
<connection>NoA connection ID; its Database Group is listedThe current connection
<environment>No. Only after <connection>.An Environment, matched exactly, ignoring caseEvery Environment

Examples

SHOW ENVIRONMENTS;
SHOW ENV;
SHOW ENVIRONMENTS db01;
SHOW ENVIRONMENTS db01 QA;

Example session

WORLD-QA> SHOW ENVIRONMENTS;
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. Rows are sorted by Environment, then by connection ID, both ignoring case; connections without an Environment come last. 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.

Other names

SHOW ENV and SHOW ENVIRONMENT are short forms of SHOW ENVIRONMENTS. SHOW GROUP, its first name, SH ENV, SHENV and SHOW ENVTS still run this command, so existing Scripts keep working. Do not confuse it with ENV QA, which switches to the Environment QA, or with SHOW ALL ENVIRONMENTS, which lists every Environment of the CDF.

Used in these how-tos

Last modified in release development.

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