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. Loan records with obsolete sublibrary code

    Loan records with obsolete sublibrary code

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description

    The ROS library was removed from the Aleph and items were relinked to other libraries. But we still find ROS loans with "ROS as the z36_sub_library: 

    LOANS 
    Code/ID Reason for reject 
    ---------------------- 
    1/000000541_000003214000140 Library not found for code = ROS. Loan originating id: 000109175 
    1/000000778_000004336000160 Library not found for code = ROS. Loan originating id: 000095226 
    1/000000534_000003214000060 Library not found for code = ROS. Loan originating id: 000096313 
    <etc.>

     

    Resolution

    The following SQL was used to overwrite the z36_sub_library with the (correct) z30_sub_library:

    update xxx50.z36 set z36_sub_library = (select z30_sub_library from xxx50.z30 where z36_rec_key = z30_rec_key) where z36_sub_library = 'ROS '; 

     


    • Article last edited: 8-Mar-2018
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Loan receipt printing / Receipt Printer configuration
      • LOAN REPORT CIR-04
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
      2. Prod:Aleph
    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