- Article Type: General
- Product: Aleph
- Product Version: 20, 21, 22, 23
We are in the process of upgrading to Aleph v20 and would like to clean out our authorities database, prior to the upgrade. Our question is: 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?
manage15 (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 could do this:
> 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.
You can then append "XXX10" to the end of each line in the aut.numbers file as described in KB 8192-1591 ( https://knowledge.exlibrisgroup.com/...t_01_format%22 ), to give it the proper form for input to p_manage_33.
As noted in Articles 000040036 and 000038198 ( https://knowledge.exlibrisgroup.com/...or_HOL_library ), p_manage_33 can be run for the authority library. To do so, you would need to copy the ./aleph/a20_1/pcb_eng/menu-catalog-aut.xml to ./u20_1/alephe/pcb_eng/menu-catalog-aut.xml and add the lines found in the ./a20_1/aleph/pcb_eng/menu-catalog.xml to it:
<display>Delete Doc Records (manage-33)</display>
As noted in Article 000040036, p_manage_33 can *not* be run for an ADM or HOL library. ( https://knowledge.exlibrisgroup.com/Aleph/Knowledge_Articles/p_manage_33%3A__running_in_ADM_or_HOL_library ).
- Article last edited: 10/8/2013