How to delete stub z00r records left by bib record deletion
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
When a bib record is deleted it leaves a z00r record which has LDR, 005, DEL, etc, fields. Can this be removed? And, if so, how?
Resolution
You can do this:
SQL> delete from z00r where Z00R_DOC_NUMBER in (select Z00R_DOC_NUMBER from z00r where Z00R_FIELD_CODE = 'DEL ');
You should test this on your Test server before doing it on Prod.
- Article last edited: 1-Sep-2017