Deleting 8,000 bib records with same oclc number

• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
Is there any way a person can get rid system records that have the same oclc number? They
all share the 049 code of ABCD.
We have a record on our test machine that has oclc 286972 and there are about 8000 system records
that were created somehow through loader by mistake. There are no holdings attached to these
records.

Is there any way to get rid of the 8000+ systems numbers also?

Resolution:
I ran p_ret_03 like this:

csh -f $aleph_proc/p_ret_03 ABC01,oclc286972docs,pno=0000286972 > & abc01_p_ret_03.0307.js &

That has created a file $alephe_scratch/oclc286972docs which has the record numbers in it.

You need to use this file as input to p_manage_33 which will delete all the records. (If you want to save one of them, you could do so by deleting the line for that particular record number from oclc286972docs.)

Before running p_manage_33, you should check the BATCH-DELETE lines in odn01/tab/check_doc . (The setting you have right now:

!BATCH-DELETE check_doc_delete_lkr
!BATCH-DELETE check_doc_delete_item
BATCH-DELETE check_doc_delete_order
BATCH-DELETE check_doc_delete_copies
BATCH-DELETE check_doc_delete_loan
!BATCH-DELETE check_doc_delete_hold

will allow it to delete all of these.) The setting of BATCH-DELETE lines is discussed in KB 5726.