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

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

    • 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