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

[Joe Reinhardt <JReinhardt@xxxxxxxxx>]

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.