Re: Trigger Program

[Jeff Crosby <jlcrosby@xxxxxxx>]

DAsmussen@aol.com wrote:

> >  What I have wished for is being able to have a
> >  trigger program that is fired when the file is _closed_.  There are a
> >  number of instances where a batch process dumps a bunch of records into
> >  a file.  When that is done, I want the trigger to fire.  Not for each
> >  record, but just once after all records have been added to the file.
> <snip>
> May have left something out, and this won't help if multiple jobs are
> updating the file
> <snip>
> I still don't understand why this is a desirable goal...

The idea is, since it's a trigger, it's a part of the database and not
the application(s).  Multiple sources could be dumping the records.  And
yes, each source could execute a single command as the last step (after
dumping in the records), but then it's the application(s) doing it, not
the database.  Or I could write a program that goes to sleep and checks
every X minutes for new records, but then a separate job is active just
for this purpose.  Same thing with using a data queue.

It's not a big thing that I'm dying over, it just seemed a useful thing
to me. 

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