CDO$HELP.HLB  —  CDO Commands, SHOW  GENERIC
    Format

      SHOW GENERIC  type-name  [ qualifier ]   [ element-name ]  ,...

                    [ FROM DATABASE  database-name ]

1  –  Parameters

1.1  –  type-name 

    Specifies the type of the generic element whose properties you
    are displaying. This type cannot be MCS_BINARY, a subtype of MCS_
    BINARY, MCS_COLLECTION, MCS_CONTEXT, or MCS_PARTITION. See the
    Oracle CDD/Repository Information Model for information on these
    types.

1.2  –  element-name 

    Specifies the generic element whose properties you are
    displaying.

    When you use the FROM DATABASE clause, specify only one element
    name for each SHOW GENERIC command.

    Specify an asterisk (*)  wildcard character for the entire
    element-name parameter only. If you use a wildcard character
    as part of the element-name, an error occurs.

1.3  –  database-name 

    Specifies the Oracle Rdb database that contains the element. CDO
    requires this parameter for elements from an Oracle Rdb database.
    You can include wildcard characters in the database name.

2  –  Qualifiers

2.1    /ALL 

    Displays system-specified properties, such as time of creation,
    and user-specified properties, such as description, for the
    generic element and for all children.

2.2    /AUDIT 

    Displays history list entries for the generic element. The
    /AUDIT=ALL qualifier displays the history list for all children.
    CDO displays history list entries only if you specified the
    CDD$HISTORY_LIST relationship as part of this generic element's
    type definition.

2.3    /BRIEF_(default) 

    Displays user-specified properties for the generic element, and
    provides the names of direct children.

2.4    /FULL 

    Displays user-specified properties for the generic element and
    for all children. CDO displays description text only if you
    specified the CDD$DESCRIPTION property as part of this generic
    element's type definition.

3  –  Description 

    The SHOW GENERIC command displays a complete or partial list of
    properties for the generic element or elements you specify.

    If you specify the type name but not an element name, the SHOW
    GENERIC command displays all elements of the specified type
    in your default directory, provided that you have privilege to
    display them.

    You must have read access to all components of the generic
    element for CDO to display those components.

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

    You can display a field definition by specifying CDD$DATA_ELEMENT
    as the type name and the name of the field definition as the
    element name.

    You can display a record definition by specifying CDD$DATA_
    AGGREGATE as the type name and the name of the record definition
    as the element name.

    You can display indexes or constraints in an Oracle Rdb database
    element by specifying CDD$INDEX or CDD$CONSTRAINT as the type
    name and the name of the index or constraint as the element name.
    Remember to include the FROM DATABASE clause.

4  –  Examples 

  CDO>  SHOW GENERIC BOOK REFERENCE_MANUAL

      In this example, because no qualifier is specified, the SHOW
      command displays default BRIEF information. This information
      includes user-specified properties for the REFERENCE_MANUAL
      element and the names of direct children.
Close Help