Re: Trigger problem

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




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