Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    Report of bib records with HOL record but no items

    1. Last updated
    2. Save as PDF
    • 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