Library /sys$common/syshlp/CDO$HELP.HLB  —  CDO Commands, SHOW  NOTICES  Description
    The SHOW NOTICES command displays the notices at the element or
    elements you specify. CDO sends notices to elements when you:

    o  Change an element and the change affects other elements.
       For example, if you change the name of a field element in a
       database, the database element may need to be integrated.

    o  Change an element and the change affects the parent. For
       example, if you delete the name of a record element in a
       database, the database element needs to be integrated.

    o  Create a new version of an element. For example, if you create
       a new record element that appears in a program, the program
       needs to be recompiled.

    If you issue the SHOW NOTICES command for an element that does
    not have notices, CDO informs you that the element does not have
    notices.

    You can display new version notices by using the SHOW NOTICES
    command at any of the member's parents that have a CDD$NOTICE_
    ACTION property value of SUCCESS or SIGNAL.

    You can display notices that the CHANGE command generates by
    using the SHOW NOTICES command at any of the member's parents
    that have a CDD$NOTICE_ACTION property value of SIGNAL.

    CDO sends notices when you either change a member of a
    relationship with the CHANGE command or you define a new version
    of the member.

    The three types of notices that definitions receive and the
    meanings of these notices are:

    o  CDD$K_POSSIBLY_INVALID

       A definition used by this definition has changed. This change
       might affect this definition. This notice indicates the name
       of the definition that changed.

    o  CDD$K_INVALID

       A definition used by this definition changed or was removed
       from the repository. This definition is invalid. If a changed
       definition initiated the notice, the notice supplies the
       name of the definition. If a deleted definition initiated
       the notice, the notice does not supply a definition name.

    o  CDD$K_NEW_VERSION

       A new version of a definition used by this definition was
       created. The notice supplies the name of the definition that
       has the new version.

    o  CDD$K_CHILD_USAGE

       A relationship from one of the definitions used by this
       element to one of its children was changed. The notice
       indicates the owner of the changed relationship. You cannot
       generate this type of notice using CDO. Only programs using
       the Oracle CDD/Repository callable interface can cause this
       notice. You can, however, read this type of notice using CDO.
Close Help