RE: Trigger Program -- RPG400-L


Thanks for all your responses.

I think i will skip the trigger part & go for journaling the file. I am new
to the journaling concept . I will checkout some manuals about journaling.

Thanks again.
Gade.






"Mark A. Manske" <manske@pconline.com>@midrange.com on 12/27/99 05:09:23 PM

Please respond to RPG400-L@midrange.com

Sent by:  owner-rpg400-l@midrange.com


To:   <RPG400-L@midrange.com>
cc:
Subject:  RE: Trigger Program


A trigger may not be the best solution for what you want to achieve.
You might be better off flagging the file as a new record, and reporting
off of that flag as you update it, or use a date when added.

Another solution if you understand how-to; and I won't go into that here
is to use journaling.

You could also use the trigger to "create" a copy of the records in a file
that you report off of, then clrpfm when the report is done.

I am sure there are many other better solutions with the minds here too,
but this should give you something to consider.


-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Gade_R_Reddy@consecofinance.com
Sent: Monday, December 27, 1999 4:18 PM
To: RPG400-L@midrange.com
Subject: RE: Trigger Program



Hey Guys, another question about trigger program.

The trigger program is executed everytime for every single record ( if i
had a trigger on Insert for instance ).

Is there any way i can just run the program once after all the inserts are
done to the file???.

In my case, i dumping the data from the Web to AS400 file. I want a report
that can produce all the new records added to the AS400 File at the end of
the day automatically.

Hope i did't confuse much.

Thanks.
Gade.






Gade_R_Reddy@consecofinance.com@midrange.com on 12/27/99 03:52:03 PM

Please respond to RPG400-L@midrange.com

Sent by:  owner-rpg400-l@midrange.com


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



Thanks Guys, Its working good..

Gade.





"Mark A. Manske" <manske@pconline.com>@midrange.com on 12/27/99 03:14:59 PM

Please respond to RPG400-L@midrange.com

Sent by:  owner-rpg400-l@midrange.com


To:   <RPG400-L@midrange.com>
cc:
Subject:  RE: Trigger Program


The easiest way to create a copy of the test file that it currently is
"built" over.  add the trigger to the test file(addpftrg), start your
debug,
but do not call the pgm, use dfu, or dbu to add/change a record
interactively, and then your trigger will be running and breaking for you.
Granted, this worked really slick for me on an ILE trigger program, I have
not tried this method using older coding techniques.  Don't forget to
remove
the trigger from your test file (rmvpftrg). Hope this helps


-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Gade_R_Reddy@consecofinance.com
Sent: Monday, December 27, 1999 2:00 PM
To: RPG400-L@midrange.com
Subject: Trigger Program



Please let me know how do we debug a Trigger program??.

Thanks.
Gade.



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



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