Report of bib records with HOL record but no items
- Article Type: General
- Product: Aleph
- Product Version: 19.01
Description:
We have many BIB records that we imported and added a holdings record but no item record. I'd like to retrieve these records in order to add items to them. I've been looking in "Services" but can't figure out how to retrieve these records.
Resolution:
The following SQL can be used to produce a report of non-deleted BIB records with an HOL record but no z30 (item) record:
SQL-ABC01>
set echo off
set pause off
set term off
set show off
set feed off
set verify off
set heading off
set pagesize 58
set linesize 09
spool bibwithhol.noitem.lst
select z00_doc_number
from z00
where z00_doc_number in
(select substr (Z103_REC_KEY_1,6,9)
from z103
where Z103_LKR_LIBRARY = 'ABC60')
minus select substr (Z103_REC_KEY_1,6,9)
from z103, abc50.z30
where Z103_LKR_LIBRARY = 'ABC50'
and substr (Z103_REC_KEY,6,9) = substr (z30_rec_key,1,9)
minus select z13_rec_key
from z13
where Z13_TITLE is null;
spool off;
- Article last edited: 10/8/2013