Re: Trigger problem

[rob@xxxxxxxxx]

You're not trying to write to the file in the trigger program are you?

I'll give you an example.  I have a trigger which updates two fields in a
file:  TIMESTAMP and USER.  The trigger program receives as input the file
buffer, updates these two fields, and sends out the file buffer.  There are
no F specs, or SQL in my particular trigger program.  If you do a WRITE in
your trigger program to the same file it will reinvoke the same trigger
program, until you stop doing writes to the file associated with the
trigger.



                                                                                
                                       
                    jfinney@omnia.co.                                           
                                       
                    za                       To:     RPG400-L@midrange.com      
                                       
                    Sent by:                 cc:                                
                                       
                    owner-rpg400-l@mi        Subject:     Trigger problem       
                                       
                    drange.com                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    10/09/00 04:15 AM                                           
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       





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
+---