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

    Deletion of Authority Records Not Linked to BIB Records

    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    We would like to clean out our authorities database.  Is there a way to delete authority records that are not linked to BIB records? Or to simply delete authority records from a file of system numbers? XXX01 has the service: Delete Bibliographic Records Including Related ADM/HOL Records (manage-33), where XXX10 does not have a similar service.

    Is there perhaps a sql query that we can use? Have any other libraries deleted large numbers of authority records?

    manage-15 (p_manage_15) could be run in the xxx01 and xxx10 libraries to clean up the headings as they appear to the catalogers, but, if you really want to delete authority records not linked to BIB records, you can perform the following steps:

    > s+ xxx10

    set echo off
    set pause off
    set term off
    set show off
    set feed off
    set verify off
    set heading off

    SQL> spool aut.numbers
    SQL> select z00_doc_number from XXX10.z00 minus select substr(z01_rec_key_4,6,9) from XXX01.z01 where substr(z01_rec_key_4,1,5) = 'XXX10';

    spool off;

    This will give you a list of doc numbers of authority records not linked to BIB records.

    2. You can then append "XXX10" to the end of each line in the aut.numbers file as described in the article " Appending library to each line in file of record numbers (make "p_ret_01 format",  to give it the proper form for input to p_manage_33.

    3. Though the menu-catalog-aut (for the authority library) doesn't include the manage-33 Service, it *can* be added and run. To do so, you would need to copy the ./aleph/a2n_1/pcb_eng/menu-catalog-aut.xml to ./u2n_1/alephe/pcb_eng/menu-catalog-aut.xml and add the following lines (found in the ./a2n_1/aleph/pcb_eng/menu-catalog.xml) to it:

    <display>Delete Doc Records (manage-33)</display>

    As noted in the Article p_manage_33: running in ADM or HOL library, manage-33 can *not* be run for an ADM or HOL library.

    • Article last edited: 10/8/2013