Re: Triggers

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.

Regards,
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