Re: Query MySQL from RPG

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!
Vern

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,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.