SQL Server data to the AS/400 -Reply

[Scott Cornell <CORNELLS@xxxxxxxxxxxxxxx>]

>>> "Rich Dotson" wrote >>>
I have a client who is looking at a package
which uses SQL Server as the data
repository

<<snip>>

My question is this:  What would be the
best way to get this data to the 
AS/400 in a pseudo real-time manner.

          ----------

Depends on what development tools you have
available.  But, there's always data queues
on the AS/400 side - ideal for just this
kind of application.  The current monitor
pgm can be modified to read the data queue,
thus de-coupling it from the client side,
e.g. it doesn't care how the entry appears
on the queue, just that it's there.  

As for the PC side, well Client Access, at
least, provides APIs (via .DLLs I believe,
so pretty much any Windows language can be
used) so that PC pgms can load an entry
into a AS/400 data queue... I'm not sure
about other connectivity options so you
might have to do some digging.  NEWS 3X/400
(or was it MidRange Computing...I don't
remember which or when, sorry :() has had
some good articles on this very subject
w/lotsa code examples (even a complete
mini-app in VB)

(Mandatory anti flame disclaimer - I have
no affiliation w/any of the companies whose
product's I just mentioned)

HTH

Scott Cornell
Mercy Information Systems

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---