Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Deleting catalogue records from particular collections

    Deleting catalogue records from particular collections

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 18

    Question

    In order to delete records from specific collections SQL shall retrieve this records by using the following command:

    select z30_rec_key from z30 where z30_collection='WIDD' and z30_material <> 'ISSUE';

    1) Can the output file from above SQL request be used as input for "Delete Item Records (item-11)"?

    2) Can we use "Delete Bibliographic Records Including Related ADM/HOL Records (manage-33)" in order to delete the BIB records afterwards? The input file for p_manage_33 must contain BIB numbers instead of item numbers. Is that correct? How can we change the numbers?

    Answer

    1) Yes, you can use the output of your SQL query as input for p_item_11. You may also use "Advanced General Retrieval Form (ret-adm-03)" in order to create a list instead of using SQL.

    2) Yes, for running p_manage_33 you need an input file with BIB system numbers. You can change the numbers in input file from p_item_11 accordingly by using p_manage_70 with option "ITEM-TO-BIB".

    Additional Information

    Please note that you delete the BIB record including ALL items and holdings with p_manage_33 and not only the records which have (had) items from specific collections (WIDD and STORE).

    Category: Cataloging (500) - ALEPH

    Subject: Items (500) - ALEPH


    • Article last edited: 8/18/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • deleting bibliographic record connected to a course
      • Deleting Empty, Unlinked Headings
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18
      2. Cataloging (500) - ALEPH
      3. contype:kba
      4. Items (500) - ALEPH
      5. Prod:Aleph
      6. Type:Q&A
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved