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



The DB2 engine on i was never more than a half baked attempt to link MySql to DB2. You can not use existing tables with MySql, nor can you use tables defined with DDS or SQL/400. They have to be defined through MySql. Granted there isn't a DB2 for i storage engine for Postgres, but you really aren't loosing all that much as long as you can get it to work in PASE. If Oracle is going to try to make MySQL just a stepping stone to Oracle DB, then they will never allow it to become fully featured for DB2, and they may even take away some existing features, or avoid adding features in the future. Hey, Oracle has not proven to be a strong open source supporter.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx

-----web400-bounces@xxxxxxxxxxxx wrote: -----
To: Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
From: Vern Hamberg
Sent by: web400-bounces@xxxxxxxxxxxx
Date: 12/18/2010 05:01PM
Subject: Re: [WEB400] MySQL and DB2 storage engine for IBM i

Good question - the DB2 engine on i for mySql was just that - a way to
store data defined in mySql in a different way. Postgresql is
self-contained, so far as I know. Does it have plugins for storage
engines that are similar to what mySql has? If not, there's no reason to
go with it. The mySql effort seems related to PHP, et al. The engine
made is possible to read mySql data in native programs. Again, no
similar purpose exists with any other RDBMS that I'm aware of.

Regards
Vern

On 12/18/2010 2:21 PM, Thorbjoern Ravn Andersen wrote:
-snip-
Why would you choose PostgreSQL instead of DB2/400 which works out of
the box?

/Thorbjørn


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.