• Subject: SQL Server data to the AS/400 -Reply
  • From: Scott Cornell <CORNELLS@xxxxxxxxxxxxxxx>
  • Date: Thu, 25 Sep 1997 13:12:17 -0400

>>> "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
+---


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].