Description

The ROS library was removed from the Aleph and items were relinked to other libraries. But we still find ROS loans with "ROS as the z36_sub_library: 

LOANS 
Code/ID Reason for reject 
---------------------- 
1/000000541_000003214000140 Library not found for code = ROS. Loan originating id: 000109175 
1/000000778_000004336000160 Library not found for code = ROS. Loan originating id: 000095226 
1/000000534_000003214000060 Library not found for code = ROS. Loan originating id: 000096313 
<etc.>
 

Resolution

The following SQL was used to overwrite the z36_sub_library with the (correct) z30_sub_library:

update xxx50.z36 set z36_sub_library = (select z30_sub_library from xxx50.z30 where z36_rec_key = z30_rec_key) where z36_sub_library = 'ROS '; 

• Article last edited: 8-Mar-2018