RE: Trigger Program

[boothm@xxxxxxxxxxxxxxxxx]

Gade, why not explain a bit more about why you wish to hold off till 
evening before doing your reports, etc?  The advantages of the trigger are 
so great, especially when you are talking of all these applications 
accessing the data base.  There is a bit of a performance hit, maybe, but 
just think of all the code you never need to write or test once you have 
your trigger executing well.  The upsides to the trigger seem pretty 
compelling to me.

_______________________
Booth Martin
boothm@earth.goddard.edu
http://www.spy.net/~booth
_______________________




Gade_R_Reddy@consecofinance.com
Sent by: owner-rpg400-l@midrange.com
12/27/1999 05:18 PM
Please respond to RPG400-L

 
        To:     RPG400-L@midrange.com
        cc: 
        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
+---