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

[rob@xxxxxxxxx]

If instead of using a row trigger you use a statement trigger would that
work?  Wait, aren't you the poor sap running V3R2?  Forget it.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    Dr Syd Nicholson
                    <sydnic@ccs400.com>       To:     midrange-l@midrange.com
                    Sent by:                  cc:
                    midrange-l-admin@mi       Fax to:
                    drange.com                Subject:     Re: system event 
trigger whenever a source file member is
                                               updated

                    03/13/2002 11:45 AM
                    Please respond to
                    midrange-l






--
[ 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.
>

--

_______________________________________________
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.