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. Different results when searching the abc01 (BIB) and abc60 (HOL) libraries

    Different results when searching the abc01 (BIB) and abc60 (HOL) libraries

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers

     

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

     


    Problem Symptoms:
    Different results when searching the abc01 and abc60 libraries ( with your library's 3-letter code)


    Resolution:

     

    “last-word-number” counter in the xxx60 library needs to be reset

    1. Run the following SQL in xxx60: 
    select max (Z97_REC_NUMBER) from z97;
    2. Select UTIL-G-2:
    3. NEW
    4. Enter sequence name: last-word-number
    5. Enter sequence start number: whatever number get from SQL above; Set leading zeros to "N".
    6. Enter prefix for format: 
    7. Do you want to suppress leading zeroes (y/n): y?
    8. Confirm (y/n) y

     

     


    • Article last edited: 12-Mar-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Different results for same search in GUI vs OPAC
      • Difficulty with semi-annual seasonal pattern
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      This page has no tags.
    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