Oninit cdi / Archive
Talk to an expert →

Re: IF Statement

Posted in 2004

Fernando Nunes — — source: Usenet: comp.databases.informix

Nicolas Mainczyk wrote: > Hi, > > I'm newbie on Informix RDBMS. > > I would like to know the equivalent syntax for the following mysql query: > > SELECT if(condition1,operation1,0),if(condition2,operation1,0),etc... FROM > table WHERE whereclause > > TIA, > Nicky. > > It seems like the more common "DECODE()" ou CASE statements. Check the SQL syntax guide. Ther is a chapter called "segments" and then go to expressions/functions or something like that... A find will be more helpful than this tips :) The SQL syntax guide is available in PDF format at: http://www-306.ibm.com/software/data/informix/pubs/library/ Regards.

Related threads