Recursive Triggers and ILE/RPG

[John Carr <74711.77@xxxxxxxxxxxxxx>]

Date:   5/21/97 12:13 PM

RE:     Recursive Triggers and ILE/RPG

>I have a trigger that updates the same file that the trigger is attached
>to. That is to say, File F has a before update trigger T. Program T updates
>file F (a different record in file F than the one that caused the trigger
>to be fired) The problem I have is that this scenario results in recursive
>calls to the RPG program.<SNIP>  Any ideas?

>Walden

Walden;
First question how does the Program T. know which update is calling it?
Either the initial one or the one it created? Second curiousity is why
are you updating the same file that you're responding to a trigger from?

Maybe in program T. you should write a data queue entry passing the trigger
parms and have it do the updating.  Or even Intra-APPC program.  
but with 30-40000 updates a nite, I might go with the Data Queue solution
and have a background job in some subsystem making the second update.  
I normally try not to use data queues because of their various 
characteristics but in a tight loop, your window of vulnerability is 
kinda low. 

John P. Carr CDP
EdgeTech 
74711.77@compuserve.com   804-739-7689
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *