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. Borrower ID's incorrect; last-bor-id and last-bor-id2 have incorrect values

    Borrower ID's incorrect; last-bor-id and last-bor-id2 have incorrect values

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 14.2

    Description:
    Temp Borrower ID's are incorrect. The util g/2 parameters last-bor-id and last-bor-id2 have incorrect values. How can a determine the proper values and reset them?

    Resolution:
    The last-bor-id is used in assigning the ALEPH user id (the z303_rec_key). Its value would depend on what prefix you use. If you have no prefix, then this SQL will give you the highest value:

    s+ cun50
    SQL-CUN50> select max(z303_rec_key) from z303;

    If you have a prefix of 'ABC', then you would do this:

    SQL-CUN50> select max(substr(z303_rec_key,4,9)) from z303 where substr(z303_rec_key,1,3) = 'ABC';.

    You would then set last-bor-id = this value in util g/2.

    Additional Information

    patron ID


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • BOR-REC-REGISTRATION-DATE Mandatory?
      • Borrowing Library Statistic Report (ill-63) p_ill_63
    • Was this article helpful?

    Recommended articles

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