Conference orarep::nomahs::repository

1093.0. "Record used by CDD$DATA_OVERLAY_CONTAINS?" by M5::GHODSON () Wed Jun 04 1997 13:47

Hi:

I have a customer with CDD 6.1 and Rdb 6.1-11 who has a record in 
CDD that she is trying to modify.  She extracted it and edited it and
is now trying to delete the existing record in CDO.  It will not
let her delete it because CDD thinks it being used.  She did a show
uses and gets the following.  

   CDO> show uses record-name
   Owners of ...
   |      *** name is unspecified ***    (Type : CDD$DATA_OVERLAY)
   |      | via CDD$DATA_OVERLAY_CONTAINS

What is this saying?  And how can she delete this record? 

Thanks for any ideas.

Gary Hodson

    Hi Gary,
    
    It says that the record is used in a VARIANT clause. You should be able 
    to modify the definitions by CHANGE RECORD command. If you use DEFINE
    RECORD, the previous record is still used by the parent record; as a
    consequence, you can't delete it.
    
    Hope this helps. 
    
    Patrick.

    Thanks Patrick.  That is exactly what I needed.  I created a variant
    containing a reference to another record, and then the SHOW USES did
    display the CDD$DATA_OVERLAY...  I should have had the customer
    just do a SHOW USES.../FULL and it would have more obvious.