Skip to main content
ExLibris

Knowledge Assistant

BETA
 
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 create a new/custom trigger in Aleph

How to create a new/custom trigger in Aleph

  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, 21, 22, 23

Description:
How can we create a new trigger, say znn_trigger_9, which would cause the column yy in the zmm table to be updated when column xx  in the znn table is updated?

Resolution:

1. Use the ./alephm/sql_tab/z105h_trigger.sql as znn_trigger_9.sql as a model, updating it appropriately for this case.  (It may be that in certain cases one of the other .slq  trigger files would be more applicable as a template for your new one.)

2. Add a znn_trigger_9 entry to the file_list of the library in which the znn table is located, like this:

  TRI znn_trigger_9

(Examples can be seen in the $aleph_root/tab/file_list.USR .) 

3. Do util a/17/6/1 to create the trigger, and util a/17/6/2 to enable the trigger.

4. Do util a/17/6/4 to confirm that the trigger has been enabled.


  • Article last edited: Feb 7, 2016
View article in the Exlibris Knowledge Center
  1. Back to top
    • How to create a new z61 (Patron Profile)
    • How to create a search index for collection description
  • Was this article helpful?

Recommended articles

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