Re: Trigger problem

[booth@xxxxxxxxxxxx]

I'm not sure I understand what you are doing.  May I repeat what I think I 
am reading? 

You have a file which has a trigger pulled when a record is being added to 
the file.  The record might be added from anywhere.  After the record has 
been successfully inserted in the file a trigger is pulled and another 
program is fired. 

The new program does not write or update a record in the triggered file, 
but the triggered file just keeps adding records, one after another, till 
you close the job in an abnormal way.

If that is a fair description then the implication is that your program 
that inserts the record is out of control.  Just for kicks, does the 
problem go away if you RMVTRG?



_______________________
Booth Martin
Booth@MartinVT.com
http://www.MartinVT.com
_______________________




jfinney@omnia.co.za
Sent by: owner-rpg400-l@midrange.com
10/09/2000 05:15 AM
Please respond to RPG400-L

 
        To:     RPG400-L@midrange.com
        cc: 
        Subject:        Trigger problem


Hi all,

Firstly, could anyone direct me to any meaningful help regarding triggers 
(I'm
having a hassle trying to find help in v4r4 softcopy library).

Now the problem . . .
I have a trigger set *AFTER *INSERT and when another pgm writes a record 
to the
pf, control is passed over to the trigger program and it seems to continue 
to
write the same record over & over. We're at OS v4r4 and I noticed two 
extra
parms on the CL cmd ADDPFTRG pertaining to threading behaviour but I don't 
think
my problem relates to these.

Any help would be appreciated.


On a lighter note, I was chatting to a person last Friday and he asked me 
what I
did for a living. Given the recent subject matter on "IBM's re-branding", 
I
thought this was the perfect opportunity to use the new name so I answered 
"I'm
a programmer on the iSeries400 platform". . . He looked at me dumfounded 
and
with his face screwed up asked "what's that". This, I thought, was to be
expected seeing that it was only announced last week. Problem is, I used 
to get
the same answer from the public at large when I told them I was a 
programmer on
the AS/400 platform !!!!!!!!!!!!!!!!!!!!!!!!

I suppose we'll see, in time, whether the re-branding/renaming is going to 
make
it easier for me to explain what it is I do.


Regards
John.








+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: 
david@midrange.com
+---




+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---