|
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
As an Amazon Associate we earn from qualifying purchases.
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.