- 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';
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