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

      SHOW RECORD  [ qualifier ] ...   [ record-name ] ,...

                   [ FROM DATABASE  database-name ]

1  –  Parameters

1.1  –  record-name 

    Specifies the record, relationship, or view whose properties you
    are displaying.

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

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

1.2  –  database-name 

    Specifies the Oracle Rdb database that contains the record. CDO
    requires this parameter for records 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
    record element and for all children.

2.2    /AUDIT 

    Displays history list entries for the record element. Specifying
    the /AUDIT=ALL qualifier displays the history list entries
    for the record element and for all children. Do not use this
    qualifier if the record you specify is from an Oracle Rdb
    database definition.

2.3    /BRIEF_(default) 

    Displays user-specified properties for the record element, and
    provides the names of direct children. /BRIEF is the default
    qualifier.

2.4    /FULL 

    Displays user-specified properties for the record element and for
    all children.

2.5    /SYSTEM 

    Format options:

       /SYSTEM
       /NOSYSTEM (default)

    Specifies whether CDO displays Oracle Rdb system relations.

2.6    /RDB_METADATA 

    Format options:

       /RDB_METADATA
       /NORDB_METADATA (default)

    Specifies whether CDO displays Oracle Rdb system relations. This
    qualifier is synonymous with the /SYSTEM qualifier.

3  –  Description 

    The SHOW RECORD command displays a complete or partial list of
    properties for the record elements you specify, provided you have
    read privilege.

    If you do not specify a full path name (or the FROM DATABASE
    clause), CDO searches your current default directory for the
    record name. If you do not specify a record name, CDO displays
    the properties of all record elements in your default directory.

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

    If you do not have read privilege for a record and for each
    component part of that record, CDO will not display the record
    name or properties.

4  –  Examples 

  CDO>  SHOW RECORD ADDRESS_RECORD
  cont>   FROM DATABASE SUBSCRIPTIONS

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