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

Description: 
We have discovered a problem with records in the Depository ADM that may have resulted from the creation of a separate administrative unit for the Depository. We have identified over 8,000 records in the Depository ADM that do not have visible ADM records, although they do have item records linked to a Depository HOL record. 

Resolution: 
abc01 bib 4862581 is supposed to be linked to dep50 ADM record 82103. Using util f/3/12, we see that there is a link in dep50: 

ENTER HOME LIBRARY : dep50 
ENTER DOC-NUMBER : 82103 
ABC01 004862581 ADM 
END 

and likewise using util f/4: 

ENTER DOC NUMBER : 82103 
CAT L $$c20080104$$lDEP50$$h1624 
001 L $$a000082103 
LKR L $$aADM$$b004862581$$lABC01 

but the link to the dep50 record is missing in abc01: 

ENTER HOME LIBRARY : abc01 
ENTER DOC-NUMBER : 4862581 
ABC60 004064560 HOL 
END 

I don't know how this happened, but it can be corrected by copying the missing z103 links from dep50 to abc01. The following SQL can be used: 

abc01@ALEPH0> insert into z103 select * from DEP50.Z103 where Z103_REC_KEY_1 like 'ABC01%' minus select * from z103; 

The site wrote: 

What we'd like to do is import this file to ABC50 as bill_temp3 (with the 13 char field z103_target) and use the following SQL: 

insert into abc01.z103 
select z.* 
from dep50.z103 z, bill_temp3 
where substr(z103_rec_key_1,1,13) = Z103_TARGET 
minus 
select * from abc01.z103; 

One of the above SQL statements was used to successfully update the abc01 z103. 

• Article last edited: 12-Mar-2016