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

    Batch changing subsets of items from one HOL to another, new HOL

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Question    
    How to batch relink certain items to a new HOL record, with a different Collection code, while leaving other items for this same Bib/ADM linked to the current HOL record, with the current Collection code?

     

    Answer    
    The Aleph service which comes closest to being able to do this is manage-62 (Update item records). It can be used to change many of the fields in the z30 (item) record, but the Z30_HOL_DOC_NUMBER_X is not one of them. This change *can* be made via SQL.... 

    Step 1: Turn off ue_01 in the xxx60 library 

    Step 2: Create a new HOL record, with 852 ... $$cANNB, linked to the bib record. Note the doc number of this new HOL record (e.g. 000123456). 

    Step 3: s+ xxx50 

    SQL> update z30 set Z30_HOL_DOC_NUMBER_X = '000123456' where (z30_rec_key >= 'xxxxxxxx1xxxx10') and (z30_rec_key <= 'xxxxxxxx1xxxx30') <or whatever conditions distinguish the items which you want to link to the new HOL from those which you do not> ; 

    Step 4: Restart ue_01 in the udm60 library. (This will propagate the $$cANNB from the new HOL 852 to the z30_collection column in the items which are connected to it via the Z30_HOL_DOC_NUMBER_X.) 

    Be sure to do this in your Test library first. Also, the standard warning: any SQL updates should be preceded by a backup of the tables to be updated (in this case, the z30).

     


    • Article last edited: 28-Feb-2016
    • Was this article helpful?