× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




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


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.