× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



But they can be the same. That's what the DB2 Storage Engine for IBM i
does. It takes MySQL tables and stores them natively in DB2 tables on i.
This makes the tables accessible via DB2 and MySQL at the same time.

And just to throw it in, it is possible to expose an existing DB2 table
via MySQL (although IBM did not include the process in the storage
engine). Currently, the process is ugly and error prone, but it does
work. I am working on a tool to automate the process and plan to release
it to the community for free.

Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi

Young i Professionals
http://www.youngiprofessionals.com



"Dennis Lovelady" <iseries@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/01/2009 09:30 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

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




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.