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. Configuring Aleph 21 for ARC 3.0, z900 triggers

    Configuring Aleph 21 for ARC 3.0, z900 triggers

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 21

    Question

    We seem to already have the Z900 Oracle table set up with the Aleph installation.
    But the triggers are not defined in the file_list definitions as they should be according to Appendix C of the Aleph Configuration for ARC3 document. Is this correct?
    How can we check if the trigger list is complete?

    Answer

    The triggers are already defined in the default file_list for ADM libraries and can be seen in the merged file list.

    You can check the merged file list definitions by using
    util a/17/10/2

    e.g.
    A.17.10. Edit file_list of XXX50 Tables

    0. Exit Procedure
    1. Edit file_list of XXX50
    2. View merged file_list
    [...]
    TRI z76_trigger_1
    TRI z601_trigger_1
    TRI z31_trigger_1
    TRI z77_trigger_1
    TRI z30_trigger_1
    TRI z30h_trigger_1
    TRI z36_trigger_1
    TRI z36h_trigger_1
    TRI z37_trigger_1
    TRI z20_trigger_1
    TRI z68_trigger_1
    TRI z16_trigger_1
    TRI z501_trigger_1
    TRI z70_trigger_1
    TRI z08_trigger_1
    TRI z38_trigger_1
    TRI z309_trigger_1
    TRI z78_trigger_1
    TRI z305_trigger_1
    TRI z13_trigger_1



    The trigger status can be checked in util a/17/6/4 Show Trigger Status

    A.17.6. Manage Triggers in XXX50

    1. Create/Recreate Library Triggers
    2. Enable Trigger
    3. Disable Trigger
    4. Show Trigger Status
    Please select [exit]: 4



    SQL*Plus: Release 11.2.0.3.0 Production on Thu Nov 7 13:49:01 2013

    Copyright (c) 1982, 2011, Oracle. All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    aleph_admin@ALEPH21> aleph_admin@ALEPH21> aleph_admin@ALEPH21> 2 3 4
    TRIGGER_NAME TABLE_NAME STATUS
    ------------------------------ ------------------------------ --------
    Z08_TRIGGER_1 Z08 ENABLED
    Z105H_TRIGGER Z105 ENABLED
    Z16_TRIGGER_1 Z16 ENABLED
    Z20_TRIGGER_1 Z20 ENABLED
    Z303_TRIGGER_1 Z303 ENABLED
    Z304_TRIGGER_1 Z304 ENABLED
    Z305_TRIGGER_1 Z305 ENABLED
    Z308_TRIGGER_1 Z308 ENABLED
    Z309_TRIGGER_1 Z309 ENABLED
    Z30H_TRIGGER_1 Z30H ENABLED
    Z30_TRIGGER_1 Z30 ENABLED

    TRIGGER_NAME TABLE_NAME STATUS
    ------------------------------ ------------------------------ --------
    Z31_TRIGGER_1 Z31 ENABLED
    Z36H_TRIGGER_1 Z36H ENABLED
    Z36_TRIGGER_1 Z36 ENABLED
    Z37_TRIGGER_1 Z37 ENABLED
    Z38_TRIGGER_1 Z38 ENABLED
    Z501_TRIGGER_1 Z501 ENABLED
    Z601_TRIGGER_1 Z601 ENABLED
    Z68_TRIGGER_1 Z68 ENABLED
    Z70_TRIGGER_1 Z70 ENABLED
    Z76_TRIGGER_1 Z76 ENABLED
    Z77_TRIGGER_1 Z77 ENABLED

    TRIGGER_NAME TABLE_NAME STATUS
    ------------------------------ ------------------------------ --------
    Z78_TRIGGER_1 Z78 ENABLED
    aleph_admin@ALEPH21> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    Additional Information

    See also article 'What is the z900 table?'

     

    • Article last edited: 11/26/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Configure Secure Cookies Creation in Apache
      • Configuring Apache for SSL - Instructions
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 21
      2. contype:kba
      3. ETL (ARC)/ARC
      4. Extract - ARC
      5. Prod:Aleph
      6. Type:Q&A
    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