Re: Trigger problem

[Jim Langston <jimlangston@xxxxxxxxxxxxxxxx>]

You do turn on the indicator LR in your trigger program, right?

Regards,

Jim Langston

jfinney@omnia.co.za wrote:
> 
> Hi,
> 
> I don't think you quite understand. It's not the triggered file which keeps
> adding records, but the output file declared within my trigger program 
>(another
> separate pf). I wrote a small pgm to populate the triggered file and ran it in
> debug mode.  Stepping through, this small pgm reads through a test file and
> simply writes each record to the triggered file.
> 
> After the first read of the test file, the pgm writes the record to the
> triggered file. Upon this write, my trigger pgm is invoked and needs to 
>extract
> certain data from the record (buffer) and insert this data into another pf. It
> is here that the trigger program keeps on writing the same record over and 
>over
> into the pf.
> 
> Furthermore, this needs to be an automated process so, just for kicks, let's
> leave the trigger program where it is and not RMVPFTRG        : - )
> 
> Regards
> John.
> 
> |--------+----------------------->
> |        |          booth@martinv|
> |        |          t.com        |
> |        |                       |
> |        |          10/10/2000   |
> |        |          02:03 AM     |
> |        |          Please       |
> |        |          respond to   |
> |        |          RPG400-L     |
> |        |                       |
> |--------+----------------------->
>   >-------------------------------------------------------|
>   |                                                       |
>   |       To:     RPG400-L@midrange.com                   |
>   |       cc:     (bcc: John Finney/ITS/Omnia Group)      |
>   |       Subject:     Re: Trigger problem                |
>   >-------------------------------------------------------|
> 
> 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
+---