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



 >> We think a very good architecture for triggers is to make a CL program the
>> actual trigger program that calls an RPG program to do the work, passing the
>> appropriate parameters.  That allows you to modify the RPG program without
>> having to remove & add the trigger on the file.

I see all kinds of problems with that, the first being that CL programs have to 
be loaded every time they are called. Lot of overhead.

I have a much better solution called a Trigger Mediator. The trigger mediator 
lives between the data base and the trigger service program. Using the trigger 
mediator, you can instantly add or remove tables from triggers and instantly 
add or remove all tables from triggers. The trigger mediator program itself 
never needs to be modified. Everything is table driven. The best part to me is 
that everything is extremely fast and you can modify the trigger service 
programs without bringing down the entire system. 

I would be glad to send you a copy of the trigger mediator and the associated 
programs to maintain the trigger tables if you want to use it.

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.