We had
a similar requirement in our AS/400 applications to send any
changed/deleted/added records from certain files as an MQ message. We use
the DB2/400 database triggers as the mechanism to initiate the process.
Because of the issues involved with database triggers, we wrote a Generic
Database Trigger process that is file driven and offers more flexibility than
using the DB2/400 db trigger directly. All the application programmer
needs to do is turn on the database trigger(s) for the desired files, add a
record to a Trigger Control File that contains information about the program to
call, and write a simple program to Put the MQ message. I would have
liked them to use a single generic program to PUT the entire record out as a
message, but the different applications had different requirements and wanted to
control it themselves, so they write the programs that PUT the
messages.
I've
attached the documentation that we give to the application programmers that
describes how to use the Generic Database Trigger process. If you are
interested in the source for the RPGLE program, let me know. It contains
only the db trigger handling process, not the MQ PUT
process.
Lynn
-----Original Message-----
From: MQSeries List [mailto:[EMAIL PROTECTED]On Behalf Of eai grp
Sent: Thursday, May 29, 2003 7:06 PM
To: [EMAIL PROTECTED]
Subject: Re: Monitor a file and put to Q
From: MQSeries List [mailto:[EMAIL PROTECTED]On Behalf Of eai grp
Sent: Thursday, May 29, 2003 7:06 PM
To: [EMAIL PROTECTED]
Subject: Re: Monitor a file and put to Q
oh I wish we could ask them to do that, but why would the applications even want to adapt.So from what you all suggest , there is nothing already available and we should write one.
Tim Armstrong <[EMAIL PROTECTED]> wrote:Can you modify the application to generate the MQ message at the time it
writes to the file? Much simpler if you can.
Regards
Tim A
eai grp
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
> cc:
Sent by: MQSeries Subject: Monitor a file and put to Q
List
<[EMAIL PROTECTED]
N.AC.AT>
30/05/2003 06:52
Please respond to
MQSeries List
Hi All,
I have a requirement , where in an application writes to an AS/400 file and
I need a tool/software?adapter that monitors this file and writes this
modified line into an MQSeries Queue.Is there something already available
or If I should write one, pls gimme a few tips if I need to Poll or trigger
(Performance Issues) etc.
Pls Suggest
Thank In Advance
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).
Instructions for managin g your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).
IFDBTRG_GenericDBTrigger.doc
Description: MS-Word document