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

    Deleted Course Reading records still show up in search results

    • 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.

    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