Ron - there are maybe 3 kinds of alternatives, basically

1. IBM's Data Integrator - uses a middleware PC - allows for standard SQL, embedded or whatever - expensive
2. Our RPG2SQL product - also uses a middleware PC - uses function calls like SQL call-level interface - no embedded SQL - not too expensive ;-)
3. JDBC - contract someone, as Rob did, or get down to learning a lot - There's an article by Kent Milligan of IBM that speaks to this - look for the works heterogeneous and database in the same title in google - site:ibm.com

<verndor response>
Our product can call SQL Server stored procedures just fine - if you want to see a demo, please give us a call at 888.RJS.SOFT or email sale@xxxxxxxxxxxxxxx - check our site at www.rjssoftware.com
</verndor response>

HTH
Vern
-------------- Original message --------------
From: "Ron Adams" <rondadams@xxxxxxxxx>

The preference would be to use an SQL Stored Procedure.

On 10/18/07, Mark Allen wrote:
We use the RPG2SQL pkg from RJS Software, works like a champ...........

On 10/18/07, rob@xxxxxxxxx wrote:

We use JDBC. We have an RPGLE program communicate, via data queues, to a
java program that uses JDBC to connect to SQL server. There's been a few
articles written here and there on how to do it. However, we were rather
busy and contracted Joe Pluta to do this for us.

Rob Berendt

--
Ron Adams

This thread ...

Follow-Ups:

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].