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. How to find records with multiple 090 fields

    How to find records with multiple 090 fields

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    We would like to get a list of Bib records that have 2 or more 090 tags. We've used the p_ret_01 service to find records with both 050 and 090, and other 09x tags, but we're stumped on how to find multiple 090's.

    If anyone has a method, either by a Retrieve service, or by SQL, please let us know.

    Resolution:
    Three possibilities:

    1. [From Mike Rogers, University of Tennessee at Knoxville, on Global Aleph Users list:]

    If you have the Z00R table, the following SQL can be used to locate such cases:

    SELECT /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */
    Z00R_DOC_NUMBER
    FROM xxx01.Z00R
    WHERE SUBSTR(Z00R_FIELD_CODE,1,3) = '090'
    GROUP BY Z00R_DOC_NUMBER
    HAVING COUNT(*) > 1;

    You'll need to change the institution code (xxx01) to your own code.


    2. [From Tania Gutman:]

    Use fix_doc_do_file_08 in tab_expand RET:

    RET fix_doc_do_file_08 more_090

    Then create a new file in your bib xxx01/tab/import directory, called "more_090" (**this can be any name you set in col.3 of tab_expand); the new file should contain:

    1 090## FIRST DELETE-FIELD

    This will virtually delete the first 090 during p-ret-01 retrieval, leaving only records with more than one 090.

    In p-ret-01, set Tag in record to "090##".


    3. [From site:]

    We discovered the Z00R table was never populated. And, with very minimal experience tweaking Aleph tables and Unix commands, not much progress via those avenues either.

    We did eventually find a work around with good old Excel. Conditional formatting found and highlighted the duplicate doc nos. in a snap.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to find problem record in input file
      • How to find staff using a particular cataloger proxy
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. 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