Re: FILE TRIGGER

When dealing with triggers, I keep the processing to an absolute minimum
within the actual trigger program. In most cases, I have my trigger
program write some identifying information to a transaction file or a
dataque. This can be done very quickly, usually without noticeable
performance degradation. I then have a server or a submitted job handle
the heavy lifting asynchronously.

HTH,

Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi



"Bryan Mangan" <bryanm@xxxxxxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/02/2010 01:27 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
<rpg400-l@xxxxxxxxxxxx>
cc

Subject
FILE TRIGGER






I have file with a trigger program attached to it and when a record is
written to this file it is suppose to execute the trigger. Once the
record is written it take a good 3 to 5 minutes to execute the trigger.
Any ideas would be appreciated.





Thank You,

Bryan Mangan



IBM Certified System i Expert



Maximum Computer Systems

3285 Veterans Memorial Highway

Ronkonkoma, NY 11779

bryanm@xxxxxxxxxxxxxxxxxxx <mailto:bryan@xxxxxxxxxxxxxxxxxxx>

Phone: 631-738-0500 Ext: 101

Fax: 631-738-6784







This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
originally addressed. If you have received this email in error or by
other means, please notify the system manager. Please note that any
views or opinions presented in this email are solely those of the author
and do not necessarily represent those of the company. Finally, the
company does not warrant that emails or attachments are without viruses
and therefore, the recipient should check this email and any attachments
for the presence of viruses. The company accepts no liability for any
damage caused by any virus transmitted by this email.