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. Deleted Course Reading records still show up in search results

    Deleted Course Reading records still show up in search results

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 19.01

    Desired Outcome Goal:
    SID field will be removed from Course Reserves professors' copies which have a "DEL Y" field and they will no longer show up in search results.

    Procedure:
    1. As a test, bring up one of the records in xxx30 GUI Cataloging and delete the SID field from the record. If this corrects the problem for this record, proceed with the following steps to batch update the other records.

    2. Run the following SQL:
    > s+ xxx30
    > select z00_doc_number from z00 minus select substr(z103_rec_key,6,9) from z103 where z103_rec_key like 'XXX30%' and z103_lkr_type = 'ITM';

    3. Spot-check the results to confirm that these are the xxx30 documents you want to delete. If not, modify the SQL to get an accurate list.

    4. Append the library to each line in the file of record numbers, as described in KB 8192-1591 {Appending library to each line in file of record numbers (make "p_ret_01 format")}

    5. Run the file-03 (Export Database Tables) to back up the xxx30 z00 (Doc) table.

    6. Connect with the GUI Cataloging client to the xxx30 library.

    7. Use the file from step 4 as input to the xxx30 manage-21 (Global change) service, specifying "SID" as the field to be deleted.

    8. If any problem, use file-04 (Import Database Tables) to restore the xxx30 $data_files backup of the table produced in step 5.

    Category: Course reading (500)

    Subject: Courses (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Deleted 852s by accident running p_manage_21
      • Deleted holdings showing in OPAC
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 19.01
      2. contype:kba
      3. Course reading (500)
      4. Courses (500)
      5. Prod:Aleph
      6. Type:General
    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