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



Why not just use the remote command function in ftp.

        FTP the data into the member and then run a program to process it
right from ftp:
        >quote rcmd call tstlibjr/testrcmd parm('deletethis')
No triggers, nothing hidden, and it will kick off the processing program -
can pass in parameters to pick up specific file and member if want to.

Joe Reinhardt
Lance, Inc.

-----Original Message-----
From: Dr Syd Nicholson [mailto:sydnic@ccs400.com]
Sent: Wednesday, March 13, 2002 10:59 AM
To: midrange-l@midrange.com
Subject: Re: system event trigger whenever a source file member is
updated


--
[ Picked text/plain from multipart/alternative ]
Hi Dan,

I need to put together a system to move data from one application to
another.

Source application - Running on VAX using Oracle. Uses FTP to place new
members in an AS/400 file (Input File)
Target application - Running on AS/400 - takes data in file member,
extracts information, and updates application database.

The target application needs to respond to new members arriving in the
Input File to make the system as real time as possible.

In the future as many as 3 input files could be used, all for different
purposes. There won't be more that 3 input files.

The OS/400 release level for this project is V3R2

If creation of a new member can trigger an action - eg send message to
message file, or a data queue - I can create a batch routine which waits
for new members arriving in the Input File and then processes them
immediately to the OS/400 database.

Syd Nicholson



Dan Bale wrote:

>Syd, could you elaborate a little on the project at hand?  Would like to
see
>how object auditing might help you here.
>
>- Dan Bale
>
>-----Original Message-----
>From: midrange-l-admin@midrange.com
>[mailto:midrange-l-admin@midrange.com]On Behalf Of Dr Syd Nicholson
>Sent: Wednesday, March 13, 2002 10:38 AM
>To: midrange-l@midrange.com
>Subject: Re: system event trigger whenever a source file member is
>updated
>
>
>Nice idea. I start a project which requires a trigger of this nature
>next week. I will investigate.
>
>Syd Nicholson
>
>
>
>R. Bruce Hoffman, Jr. wrote:
>
>>this has come up before, and I don't know, but has anybody considered
using
>>the object auditing?
>>
>>Create the audit journal receiver and journal, change object audit on the
>>file to *change and then use the RCVJRNE exit to process the records?
>>
>>While triggers are record and record group oriented, adding or changing
>>members should probably show up in the audit journal.
>>
>>===========================================================
>>R. Bruce Hoffman, Jr.
>>-- IBM Certified Specialist - iSeries Administrator
>>-- IBM Certified Specialist - RPG IV Developer
>>
>
>_______________________________________________
>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.