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

      SHOW ALL  [ qualifier ]

1  –  Qualifiers

1.1    /ALL 

    Displays system-specified properties, such as time of creation,
    and user-specified properties, such as data type, for each
    element in the directory and for all children.

1.2    /AUDIT 

    Displays history list entries for each element. AUDIT=ALL
    displays history list entries for each element and all children.

1.3    /BRIEF_(default) 

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

1.4    /FULL 

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

2  –  Description 

    The SHOW ALL command displays a complete or partial list of
    properties for all visible elements in the default directory.

    If you have your default directory set to a directory in the
    compatibility repository, the SHOW ALL command displays DMU
    record definitions of the CDD$RECORD type, but cannot display
    other definitions that may be stored in your DMU repository. Some
    examples of DMU definitions that CDO cannot display include the
    following:

    o  ACMS application, menu, task group, and task definitions

    o  DATATRIEVE domain, plot, table and view definitions, and
       procedures

    o  DBMS schema, subschemas, security schemas, and storage schemas

    o  Oracle Rdb relation, constraint, index, view, and field
       definitions

    o  TDMS form, request, and request library definitions

    When you display definitions from the compatibility repository,
    CDO displays DMU definitions in CDO format.

    You must have read access to an element for CDO to display
    information on that element.

    CDO displays type definitions only if your default directory is
    set to the CDD$PROTOCOLS directory.

3  –  Examples 

  CDO>  SHOW ALL

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