Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ADM records not visible

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description: 
    We have discovered a problem with records in the Depository ADM that may have resulted from the creation of a separate administrative unit for the Depository. We have identified over 8,000 records in the Depository ADM that do not have visible ADM records, although they do have item records linked to a Depository HOL record. 

     

    Resolution: 
    abc01 bib 4862581 is supposed to be linked to dep50 ADM record 82103. Using util f/3/12, we see that there is a link in dep50: 

    ENTER HOME LIBRARY : dep50 
    ENTER DOC-NUMBER : 82103 
    ABC01 004862581 ADM 
    END 

    and likewise using util f/4: 

    ENTER DOC NUMBER : 82103 
    CAT L $$c20080104$$lDEP50$$h1624 
    001 L $$a000082103 
    LKR L $$aADM$$b004862581$$lABC01 

    but the link to the dep50 record is missing in abc01: 

    ENTER HOME LIBRARY : abc01 
    ENTER DOC-NUMBER : 4862581 
    ABC60 004064560 HOL 
    END 


    I don't know how this happened, but it can be corrected by copying the missing z103 links from dep50 to abc01. The following SQL can be used: 

    abc01@ALEPH0> insert into z103 select * from DEP50.Z103 where Z103_REC_KEY_1 like 'ABC01%' minus select * from z103; 


    The site wrote: 

    What we'd like to do is import this file to ABC50 as bill_temp3 (with the 13 char field z103_target) and use the following SQL: 

    insert into abc01.z103 
    select z.* 
    from dep50.z103 z, bill_temp3 
    where substr(z103_rec_key_1,1,13) = Z103_TARGET 
    minus 
    select * from abc01.z103; 

    One of the above SQL statements was used to successfully update the abc01 z103. 

     


    • Article last edited: 12-Mar-2016