CDO$HELP.HLB  —  CDO Commands, SHOW  NOTICES  Examples
    1.CDO>  SHOW NOTICES EMPLOYEE_REC
         .
         .
         .
      CDO>  CLEAR NOTICES EMPLOYEE_REC

      In this example, the SHOW NOTICES command displays notices
      sent to the EMPLOYEE_REC record. You can clear any notices by
      issuing the CLEAR NOTICES command.

    2.CDO>  CHANGE FIELD FLD_A
      cont>   DATATYPE IS SIGNED LONGWORD.
      %CDO-I-DBMBR, database DISK1:[SMITH.DICT]MY_RDB_DB(1) may need to be
        integrated
      CDO>  SHOW NOTICES MY_RDB_DB
      DISK1:[SMITH.DICT]MY_RDB_DB(1) is possibly invalid, triggered by entity
      DISK1:[SMITH.DICT]FLD_A(1)
      CDO>

      In this example, CDO sends a notice that a database might
      require integration as a consequence of the CHANGE command.

      You can use the SHOW NOTICES command to display this notice at
      the MY_RDB_DB database definition.

    3.CDO>  DEFINE FIELD FLD_B
      cont> DATATYPE SIGNED LONGWORD.
      CDO>  SHOW NOTICES REC_B
      DISK1:[SMITH.DICT]RDB_REC_B(1) uses an entity which has new versions,
      triggered by CDD$DATA_ELEMENT DISK1:[SMITH.DICT]FLD_B(1)
      CDO>  SHOW NOTICES MY_RDB_DB
      DISK1:[SMITH.DICT]MY_RDB_DB(1) uses an entity which has new versions,
      triggered by CDD$DATA_ELEMENT DISK1:[SMITH.DICT]FLD_B(1)
      DISK1:[SMITH.DICT]MY_RDB_DB(1) is possibly invalid, triggered by
      CDD$DATA_ELEMENT DISK1:[SMITH.DICT]FLD_A(1)

      When you create a new version of the FLD_B field definition by
      using the DEFINE FIELD command, CDO sends new version notices
      to the parents of FLD_B. The following set of examples shows
      this sequence of events:

      1. The DEFINE FIELD command creates a new version of the FLD_B
         field definition.

      2. The first SHOW NOTICES command shows that FLD_B's immediate
         parent, REC_B record definition received the new version
         notice when CDO created the new version of FLD_B.

      3. The second SHOW NOTICES command shows two notices at the
         MY_RDB_DB CDD$DATABASE definition. The CHANGE command sends
         one notice on behalf of the FLD_A field definition from the
         previous example, and the DEFINE FIELD command sends a new
         version notice on behalf of the new version of the FLD_B
         field definition.

    4.CDO> CLEAR NOTICES MY_RDB_DB
      CDO>  SHOW NOTICES MY_RDB_DB
      %CDO-I-NONOTICES, DISK1:[SMITH.DICT]MY_RDB_DB(1) has no notices

      To clear the notices at MY_RDB_DB, use the CLEAR NOTICES
      command.

      To verify that you cleared the notices at MY_RDB_DB, use the
      SHOW NOTICES command. If you ask to see the notices at a
      definition without notices, CDO responds that there are no
      notices.
Close Help