Physically deleting bibliographic records
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
The Aleph routines which delete z00 "doc" records (bib, authority, HOL, etc., records) just *logically* delete them. They always leave a stub record (with "DEL $$aY", LDR, FMT, and CAT fields). Is it possible to *physically* delete Aleph bib, authority, and other doc records?
Resolution
There is no Aleph routine which physically deletes doc records. But, if the library is a Bib, Authority, or Course library, SQL like the following can be used to physically delete the stub records left by the logical deletion:
SQL> delete from z00 where z00_doc_number in (select z13_rec_key where z13_title is null);
(Z13 records with a blank z13_title are ones whose bib record has a DEL=Y field.)
This article discusses the handling of Z00R records: How to delete stub z00r records left by bib record deletion .
- Article last edited: 1-Sep-2017