SHOW ALL ENVIRONMENTS

Core command SHALENV SHOW ALL ENVTS

Lists every Environment of the CDF, active or inactive, with its Production flag.

Syntax

SHOW ALL ENVIRONMENTS

Examples

SHOW ALL ENVIRONMENTS;

Example session

WORLD-QA> SHOW ALL ENVIRONMENTS;
|---------------|---------------------------------------------|----------|
|ID             |DESCRIPTION                                  |PRODUCTION|
|---------------|---------------------------------------------|----------|
|IN             |Integration                                  |false     |
|LOCAL          |Local                                        |false     |
|PROD           |Production                                   |true      |
|QA             |Quality assurance                            |false     |
|---------------|---------------------------------------------|----------|

4 environment(s) 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

One row per Environment, active and inactive alike (ID, Description, Production), sorted by ID, followed by the number found, in the same table layout as SHOW ALL CONNECTIONS.

The list does not depend on the current connection: it is always every Environment of the CDF. Do not confuse it with SHOW ENVIRONMENTS, an older name of SHOW GROUP, which lists the connections of the current Database Group.

Used in these how-tos

How do I set up QA and production copies of WORLD to practise environment commands?

Last modified in release 5.5.0.

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