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. No Value Shows in Query Studio When More Than 1 Query Item Inserted

    No Value Shows in Query Studio When More Than 1 Query Item Inserted

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

    Description:
    This problem is most serious when we use the Query Studio of ARC in the Bibliographic Data section. When we insert the first query item as a column e.g., "Bib Library", we get the values of vcu01 and vcu30. However, whenever we insert a second query item (column) e.g., "No of Records", we get nothing except two headings. We know there are Bibliographic data in the data warehouse, but we wonder why when we add a second column, nothing except the headings shows up.

    Resolution:
    The problem is that your Z106 table is empty, so there is no information available to the report.

    The Z106 table contains information about record updates. When a cataloging record is updated, a “CAT” field is built in the record. This field identifies the cataloger who created or updated the record, the date and time of update, the cataloger level, and the cataloger’s library. The CAT field supplies the data for the Z106 table.

    The Z106 records can be created automatically when records are updated by setting the CREATE-Z106 flag from the tab100 table of the library’s tab directory to ‘Y’. This flag determines whether a Z106 record is created automatically each time a cataloging record is created or updated. If the flag is set to ‘N’, then record updates will not automatically generate Z106 records. In this case, the Z106 records can be created by running the “Create/Update Z106 Table for "CAT" Field” (manage-19) service. This service is available from the Catalog Maintenance Procedures option of the Services menu in the Cataloging module.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • No tab_md_ns_info in usm01 $data_tab
      • no word breaking routine was found for: L $$aanalculint
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      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