RE: ERP data bridged interactively to WMS

["Alex Moore" <alexm@xxxxxxxxxxxxxxxx>]

We use a trigger on the ERP data to write to a data queue.  This allows you to 
rest assured you got each and every database change,
without delaying the ERP package at all.  We found from experience (and by 
going back and actually RTFM) you don't want to perform a
lot of work (time) in a trigger program.  There are some issues when a trigger 
is attached to a file (backup/restore, copyfile
etc.), but the advantages outweigh the disadvantages.

The data queue is then processed by whatever means you see fit...sockets, DDM 
file, data queue read by remote system, etc.

Alex A. Moore ~ CIO
Ellis Hosiery Mills, Inc.
alexm@ellishosiery.com <mailto:alexm@ellishosiery.com>


> I am currently specifying an interface from an AS400 based sales order
> system (JBA) to an external warehousing system.  At the moment, I do not
> know which warehousing system this will be or indeed the platform (AS400, NT
> or Unix).  I have done this before but the difference this time is that the
> interface is to be done interactively, not in batch, in the past I have used
> FTP to send and retrieve files to the remote host.
>
> Does anyone have a suggestion for a possible solution to the problem.  This
> is still at an early stage so I have a good chance of pushing this the way I
> want it to go (AS400).  Whatever the remote host is to be, I am sure it will
> be running TCP/IP so would the use of sockets be the way to go?  If so where
> do I start (RPG preferred).

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---