• 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