Returns a list of available catalog information with catalog name, catalog type (primary or auxiliary), and catalog status (default or not default).

Syntax

SHOW CATALOGS [ ALL |{ PRO_NAME | PRO_TYPE | PRO_STATUS }  
              [ , PRO_NAME | PRO_TYPE | PRO_STATUS } ;

Parameters

ALL

Return all attributes.

PRO_NAME

List of catalog names.

PRO_TYPE

List of catalog types (primary or auxiliary).

PRO_STATUS

List of catalog statuses (default or notdefault)

Notes

  • This statement is useful for obtaining the catalog names of databases currently connected for the user, for identifying the catalog name of the primary database (automatically connected) and the current default catalog.
  • The primary database connection is automatically given a catalog name which is the name of the primary database. For example, if the database is at /usr/progress/sports2000, then the catalog name for the primary database is sports2000.
  • Three columns of information are returned by the SHOW CATALOG statement. These are the catalog name, catalog type (primary or auxiliary) and status (default or notdefault).

Example

In this example, the names of the currently available catalogs are returned.

SHOW CATALOGS PRO_NAME;