Re: system event trigger whenever a source file member is updated

[Dr Syd Nicholson <sydnic@xxxxxxxxxx>]

--
[ Picked text/plain from multipart/alternative ]
Unfortunately, I have no flexibility or control over the software
sending the FTPed data. The data will arrive in a new file member and my
program needs to respond to this.

I have thought about file triggers, and I could make it work this way.
The disadvantage is that every new record will invoke the trigger. Each
member could receive several hundred records, causing the the trigger to
invoked be hundreds of times for each member added. What I would like is
a trigger that will be invoked just once for each member added.

Of course, what I would like, and what I have to work with are two
different things.

Syd Nicholson



Leif Svalgaard wrote:

>From: Dr Syd Nicholson <sydnic@ccs400.com>
>
>>Source application - Running on VAX using Oracle. Uses FTP to place new
>>members in an AS/400 file (Input File)
>>
>
>You can trigger on the writing to the file (by FTP) and if you also FTPed
>a small control file with the name of the member you can go from there.
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>

--