Re: Query MySQL from RPG

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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.