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

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

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