× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. May 2013

Re: Two trigger programs allowed on a file. Maybe more allowed?

On 5/20/2013 9:44 AM, Eric Lehti wrote:
I succeeded in attaching a second trigger program to a file yesterday.
Happy. I did not realize that system will allow more than one trigger
program.

I did not want to modify the existing (first) program trigger that
tracks sales order totals in real-time.

I created second trigger program with JD Edwards DBAM (data base audit
manager) to identify which process is changing info in one field.

How many trigger programs will system allow on a file? I will find out
someday.

ADDPFTRG
F1 (Help)
F2 (extended help)

IBM i 7.1 says: 'A maximum of 300 triggers can be added to one physical
file. The trigger program to be called can be the same for each trigger
or it can be a different program for each trigger.'

--buck

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.