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 -

<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
</verndor response>

-------------- 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 On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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