Re: death knell for Informix
- From: "Art S. Kagel" <kagel@xxxxxxxxxxxxx>
- Date: Thu, 26 Apr 2007 10:23:29 -0400
Philip Nelson wrote:
Serge Rielau wrote:
Data Cruncher wrote:http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9017838
IBM to open its midrange systems to MySQL's database
What does that have to do with IDS?
IDS doesn't run on iSeries.
There are exactly 2 things at work here:
1. Enabling of mySQL on iSeries (good for iSeries)
2. Enabling of mySQL directly on DB2 for iSeries (without dependency on
another storage engine) (still good for iSeries)
Depending how one reads the articles one may suspect that IBM will
provide soem help to get mySQL closer to the SQL Standard.
I sure would love to see mySQL users stop nagging: DB2 is bad because
"SELECT 1+2" returns an syntax error ... ;-)
Cheers
Serge
Or even -
SELECT * FROM TABLE WHERE integer_column = '1';
Came across this during my work on Ruby on Rails !!!
You can put quotes around the literals for any data type in MySQL and it
works.
Works in IDS and all other Informix versions as well as long as the value in quotes is convertable to the type of the column (or vice-versa since the optimizer is free to convert the row values to strings for the comparison if it determines that it's more efficient to do so (rare I know). Informix engines have had such automatic conversions since the first SE release. And Serge is right, this has nothing to do with the IBM Informix product line which doesn't run on iSeries or any other non-UNIX platform other than Windoze.
Give it up folks. Informix isn't going anywhere but up! Nine of the world's ten largest retailer organizations, two of the world's largest telecom companies, the world's largest manufacturer of network routers, several of the world's largest airlines, and the world's largest military organization all use Informix database servers. Get over it and get on with it!
Hope to see you all in San Jose! Oh, and watch out for Cheetah crossings. ;-)
Art S. Kagel
.
- Follow-Ups:
- Re: death knell for Informix
- From: Zachi
- Re: death knell for Informix
- Prev by Date: Re: Bug in JDBC Driver with use of Bulk Insert and Money Data Type
- Next by Date: JDBC Informix connect
- Previous by thread: Re: death knell for Informix
- Next by thread: Re: death knell for Informix
- Index(es):
Relevant Pages
|
|
