Format

      SHOW DATABASE  [ qualifier ]   [ database-name ]

1  –  Parameters

1.1  –  database-name

    Specifies the physical database whose properties you are
    displaying. By default, if you do not specify a full path name
    for the database, CDO displays all physical database elements in
    your default directory.

2  –  Qualifiers

2.1    /ALL

    For an RMS database, displays the database name and description,
    record definition, file organization, fully qualified path name,
    and system-specified properties.

    For an Oracle Rdb database, displays the database name, file
    name, and fully qualified path name, as well as the system-
    specified properties.

2.2    /AUDIT

    Displays the history list entries for the database definition.
    The /AUDIT=ALL qualifier displays the history list for all
    elements owned by the database.

2.3    /BRIEF_(default)

    For an RMS database, displays the database name and description,
    record name, fully qualified path name, and file organization
    properties.

    For an Oracle Rdb database, displays the database name, file
    name, and fully qualified path name.

2.4    /FULL

    For an RMS database, displays the database name and description,
    record definition properties, file organization properties, and
    fully qualified path name.

    For an Oracle Rdb database, displays the database name, file
    name, and fully qualified path name.

3  –  Description

    The SHOW DATABASE command displays a complete or partial list of
    properties for the database elements specified.

    If you do not specify a version number for a database element,
    CDO displays the highest visible version.

    When you use the SHOW DATABASE command to display an Oracle Rdb
    database element, CDO shows only the database name, file name,
    and the fully qualified path name. Use the SHOW GENERIC command
    with the /FULL qualifier or use SQL (structured query language)
    to view the complete definition of an Oracle Rdb database.

4  –  Examples

  CDO>  SHOW DATABASE DEPT5

      In this example, because no qualifier is specified, the SHOW
      DATABASE command displays default BRIEF information. This
      information includes the DEPT5 Oracle Rdb database name, file
      name, and fully qualified path name.