Re: death knell for Informix

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

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

Philip Nelson wrote: > 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. Are to talking to folks in the lab? I got the same request internally yesterday! DB2 for iSeries actually supports this. The days of strong typing in SQL are clearly numbered. Like it or not :-( Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab

On Apr 26, 10:23 am, "Art S. Kagel" <k...@bloomberg.net> wrote: > 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! The Chinese military is using Informix? Zachi