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

    SQL to update the 852 subfield h

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

    For all the records with a sub-library of MEDIA that have the 852 subfield h set to '0', we want to change the 852 subfield h to '8'. The problem is that there are so many records it would take months to change them using the GUI, so we would like to change it programmatically.

    I know that the 852 subfield h is the z30_call_no_type in the ABC50.Z30 and ABC50.Z30H. I also know that the HOL record containing that field is in ABC60 somewhere, but I do not know where. So here is my question:

    If I write a SQL program to update the 852 subfield h, in what tables is the value stored? Or, to put it another way, what fields, in what tables, in what databases need to be updated?

    As described in KB 8192-4359, the HOL record (and all of the ALEPH z00 doc records) are stored in Binary-Long Object format. You can not run SQL against them.

    You will need to do this:

    1. Run p_ret_01 in ABC60 to locate the relevant HOL records.

    2. Use the output file of record numbers from step 1 as input to the p_manage_21 Global change (in ABC60). The change made by p_manage_21 will be propagated to the associated item records.

    3. The update to the HOL record will also generate z07 records in the bib library, which will be processed by the bib ue_01, which will update the bib library call number indexes.

    • Article last edited: 10/8/2013
    • Was this article helpful?