SQL update of item sublibrary, collection, and call number fields don't update indexes
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
Changes to the item sublibrary, collection, or call number made via SQL do not update the Bib, ADM, or HOL library indexes.
Cause:
Updating items via SQL does *not* create z07s (indexing requests).
Resolution:
To make z07's be created ...
1. make the change via the GUI or via the manage-62 (Update Item Records)
or
2a. use the item number file as input to manage-70 (Retrieve Record Keys), specifying ITEM-TO-BIB as the "Convert Type", and then
2b. use the file produced by 2a as input to xxx01 manage-40 (Update Indexes for Selected Records) which will generate a z07 for each bib record, which will then be processed by the xxx01 ue_01.
Additional Information
As noted in Article 000022292 ("Item sublibrary, collection, and call number updates do not work"), direct updates to items do not work at all when X852-ITEM-OVERRIDE=Y (or z30_temp_location = "N").
Note: Your Oracle license may not permit the updating of records in Oracle via SQL.
- Article last edited: 2/10/2014