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

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

     

    • 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
    • Was this article helpful?