Hi Eric,

I never did see the original for this.  One software vendor I know of
actually has a CL trigger program that calls an RPGLE program that reads a
file keyed by file name - each record contains the name of a trigger program
and a status flag as to whether that trigger program is active or not -- and
for each active record, calls the trigger program.  Oh, and that's not all.
It also reads another file to determine whether changes triggered by a
particular user are processed or not.

I'm not advocating this method, I'm simply stating that it's in use.  And
yes, performance was not what you'd call optimal.  For normal user updates
via the application it could keep up.  But once one of the analysts did an
SQL UPDATE (the user profile was not in the "ignore" file) and it took a
couple of hours for the trigger programs to catch up.

I think the data queue method mentioned by Alex Moore is a far better method
of handling the requirement.

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

----- Original Message -----
From: "Scott Mildenberger" <Smildenber@Washcorp.com>
Sent: Wednesday, December 05, 2001 9:40 AM
Subject: RE: Triggers

> Not on V4R5 or earlier but I seem to remember seeing something like this
> being available on V5R1, not positive though so you would have to check it
> out.

> > -----Original Message-----
> > From: Eric Wolf [mailto:eric_a_wolf@hotmail.com]
> > Sent: Wednesday, December 05, 2001 10:48 AM
> > Subject: Triggers
> >
> >
> > Is it possible to have more than one Insert/After or
> > Change/After trigger?

Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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-2022 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.