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. Batch jobs to clean out patron note fields

    Batch jobs to clean out patron note fields

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description

    Are there batch jobs or Services to update or clean out patron note fields?

    Resolution

    The patron records have the following note fields:

    Z303-FIELD-1 (Global Note 1)
    Z303-FIELD-2 (Global Note 2)
    Z303-FIELD-3 (Global Note 3)
    Z303-NOTE-1  (Additional Note 1)
    Z303-NOTE-2  (Additional Note 1)

    Z305-FIELD-1 (Local Note 1)
    Z305-FIELD-2 (Local Note 2)
    Z305-FIELD-3 (Local Note 3)

    There are no batch Services to update or remove data from these fields.  Blanking out of these fields would need to be done via SQL, such as the following:

    SQL> update z303 set z303_field_n = NULL where z303_field_n is not NULL;
    SQL> commit;

    Before running any such SQL, you should use the file-03 Service to back up the affected table (z303 and/or z305).

    Note:  There are also Z303-DELINQ-n ("Global Block n") and Z305-DELINQ-n (Local Block n") fields.  These fields can either use default text from tab31, or they can contain text specific to this particular patron's situation.
     

     

     


    • Article last edited: 8-Mar-2018
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Batch Jobs Summary Report (sys-90) reports "done with Errors"
      • Batch jobs which add/update HOL records stall
    • Was this article helpful?

    Recommended articles

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