RE: Fastest way to get a unique identifier/tracking column

["Reeve" <news@xxxxxxxxxx>]

What???  Business applications actually abend?  :)

I need multiple triggers because the "historical changes" file will be the
repository for many application files' data.  In addition, I'm going to have
other logic in the triggers (updating header records with status and total
information).

If I decide not to add the logic to the trigger programs, I'll read the
journal receivers.

-reeve

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
> bounces@xxxxxxxxxxxx] On Behalf Of Mike savino
> Sent: Monday, July 12, 2004 4:16 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: Fastest way to get a unique identifier/tracking column
> 
> Reeve,
> 
> I'm confused about why you'll need multiple Trigger programs in the first
> place.  Unless you intend to do your column filtering in the Trigger
> program
> itself.  In which case I'd advise you not to make the Trigger pgm any
> more
> complicated than absolutely necessary.  Don't forget that the Trigger
> runs
> as part of the business app.  Get your Unique Id, write the data to a Flat
> File, pass the Id to a Data Queue and be done with it.  Let a separate
> process that monitors the Data Queue do whatever more sophisticated
> processing you might need.  I think that limits the potential for the
> Trigger pgm to abend and somehow mess up your business app or to
> slow down
> the app if you've got to do additional I/Os.  Just my Opinion.
> 
> Mike
> 
> _____________________________________________________________
> ____
> Get fast, reliable Internet access with MSN 9 Dial-up - now 2 months
> FREE!
> http://join.msn.click-url.com/go/onm00200361ave/direct/01/
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.