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



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.







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.