Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Occurrences of Obsolete Material Types

    Occurrences of Obsolete Material Types

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    I have encountered a number of occurrences of obsolete material types in our system (see the 2 examples).
    Is there an SQL command that could be run to see how many occurrences of non-valid material types there are in our data (material types other than those specified in XXX50/tab25.eng) and then change them to valid values?

    Resolution:
    You can use the following SQL to find non-valid material types:
    SQL-xxx50> select z30_material, z30_rec_key from z30 minus select z30_material, z30_rec_key from z30 where z30_material in ('ISSUE', 'ISSBD');
    After ISSBD you would include all of your other tab25 material types, separated by commas.
    Assuming these results seem correct, you can use this SQL to change them:
    SQL> update z30 set z30_material = 'yyyy' where z30_material = 'xxxxx';
    The number of "Rows updated" should match the results for that z30_material type in the preceding "select".
    You should, of course, back up the z30 table (using p_file_03) before performing any Update.
    When updating z30 records with SQL one needs to consider whether the field being updated is one included (via expand) in BIB library indexes. Though the Material type is included in the LOC and PST expands (subfields "o" and "3"), it is not likely that it is actually being indexed. You can check your tab11_'s to be sure.

    Additional Information

    material types, obsolete


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Obtaining a random sample via p_ret_01
      • OCI fails to connect to Oracle
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
      2. Prod:Aleph
      3. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved