RE: MySQL on i using DB2

Not if you use the DB2 connector as the database engine. MySQL alone is not a database. It is only a frontend to a database engine. There are multiple options to use as a database engine behind MySQL and DB2/400 is now one of them. So you can actually present a front end that looks like mySQL to an application written to the mySQL standard but use DB2 as the database engine.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dennis Lovelady
Sent: Tuesday, December 01, 2009 10:29 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: MySQL on i using DB2

So the short answer is yes you can do exactly what you are asking.

I must apologize; I read something into the question that wasn't there.

I thought the op wanted to connect to DB2 data (i.e. a library/file object)
using a mySQL connection. I was thrown off by this confusion:
"Could I write a application ... i and have it access the
> mySQL database (actually DB2)"

Actually this is NOT DB2, or my prior response applies. mySQL may exist on
a DB2 machine (the i), but that does not make it a DB2 database. The two
may coexist, but are not the same. They contain different data, different
tables, et cetera.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"I don't want to belong to any club that would accept me as a member."
-- Groucho Marx