Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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.

    Updating items via SQL does *not* create z07s (indexing requests).

    To make z07's be created ...

    1. make the change via the GUI or via the manage-62 (Update Item Records)
    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