Joe & Mike

You are not getting the drift - wow! Dan assumes, I think, that y'all remember embedded SQL and the WRKRDBDIRE command - to talk to remote databases. We use it to run SQL on a remote iSeries box. But also any DB2 database on mainframes or Unix or Windows. That's what he means by "directly" - JDBC is not direct in this sense. Neither is IBM's WebSphere Information Integrator - nor our RPG2SQL - both use an intermediary PC.

What he is talking about is writing an ARD - something to make MySQL usable in a DRDA environment like embedded SQL. No calls to functions in JDBC, not even nice calls like we have in our RPG2SQL product - Dan and I work together, by the way, and I know I wish there had been this kind of thing years ago.

The only vendor that has an ARD is Oracle, these days. Mighta useta been one for SQL Server and for a couple other RDBMS', but they got lost somehow.

Oh - you might be able to use iSeries syntax - not sure.

So take a look at ADDRDBDIRE for a reminder - and press F9 to see the parameter no one ever used - ARDPGM - that is what Dan wants the community to write.

Hope this makes sense!

At 07:59 PM 3/24/2008, you wrote:

----- Original Message -----
From: <dkimmel@xxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Monday, March 24, 2008 5:42 PM
Subject: Query MySQL from RPG

> Would you like to work on a project to make MySQL available directly from
> RPG programs on the System i?

Isn't this already possible using JDBC? I know it can be done with MSSQL,
so I assume MySQL would work as well.

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

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