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

    Globally changing patron's sublibrary

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    All library patrons who were formerly assigned to the QRSH library are now at "WO"

    How do I go about changing all of them to WO as their sublibrary?

    Resolution:
    A sublibrary can be stored in four places for a patron: the z303_ill_library, z303_home_library, z303_dispatch_library, and the Z305-SUB-LIBRARY (bytes 13-17 of the z305_rec_key). All are optional.

    The following SQL shows that you have *zero* patrons with "QRSH" as a value in the z303 record:

    abc50@ALEPH0> select count(*) from z303 where Z303_ILL_LIBRARY = 'QRSH ';
    **** Hit return to continue ****

    COUNT(*)
    ----------
    0

    1 row selected.

    abc50@ALEPH0> select count(*) from z303 where Z303_HOME_LIBRARY = 'QRSH ';
    **** Hit return to continue ****

    COUNT(*)
    ----------
    0

    1 row selected.

    abc50@ALEPH0> select count(*) from z303 where Z303_DISPATCH_LIBRARY = 'QRSH ';
    **** Hit return to continue ****

    COUNT(*)
    ----------
    0

    The following SQL shows the counts of each Z305-SUB-LIBRARY value in the z305 records:

    abc50@ALEPH0> select substr (z305_rec_key,13,5), count(*) from z305 group by substr (z305_rec_key,13,5);
    **** Hit return to continue ****

    SUBSTR(Z305_REC COUNT(*)
    --------------- ----------
    ABC50 2105
    ...
    QRSH 466
    ...
    WO 928
    XYZAN 164


    It is *not* necessary to have z305 records with the sublibrary as the Z305-SUB-LIBRARY value. Assuming you have the situation described in KB 16384-35 (where the values in the QRSH z305 are the same as those in the patron's ABC50 z305), you can simply delete the QRSH z305 records. In each case you will find that the patron *does* still have a
    z305 with a Z305-SUB-LIBRARY of "ABC50". This is demonstrated by the following SQL:

    abc50@ALEPH0> select substr (z305_rec_key,1,12) from z305 where substr (z305_rec_key,13,4) in (select substr (z305_rec_key,13,4) from z305 where substr (z305_rec_key,13,4) = 'QRSH')
    2 minus select substr (z305_rec_key,1,12) from z305 where substr (z305_rec_key,13,5) in (select substr (z305_rec_key,13,5) from z305 where substr (z305_rec_key,13,5) = 'ABC50');

    no rows selected

    The ABC50 Z305 is perfectly adequate for all circulation purposes.

    Alternatively, you could update the Z305-SUB-LIBRARY to "WO " where the Z305-SUB-LIBRARY is "QRSH ". Note that the Z305-SUB-LIBRARY is not in the z305 SQL DESCription, and can be addressed only as substr (z305_rec_key,13,5).

    Be sure to back up the xxx50 z305 (using p_file_03) before doing any such deletion or change.

    Additional Information

    faq


    • Article last edited: 4/16/2014
    • Was this article helpful?