Re: Informix equivalents for Decode, NVL, CASE-WHEN-THEN

Jarrod Roberson wrote: > informix ids has decode, case, nvl all that. More precisely, version 7.3 has all these facilities. Some of the 8.x versions have CASE. IDS/IUS (9.x) can be given DECODE and NVL by writing functions of those names. The Centaur release (probably 7.4/9.2, but that could change by release time, later this year) will have the facility. And you can write a moderate facsimile of the functions (but not CASE) in SPL, though it is not very fast. > blacklungs wrote in message <7eturu$cf9$1@news.kren.nm.kr>... > >Sorry if the question sound amateur, but I am looking for Informix > >implementation for conditional statements/functions/procedures that > >can do what I used Decode, and NVL in Oracle. > > > >I have limited Informix experience, and moderate experience with > >Oracle and Sybase. > > > >What I need to is construct a single SELECT statement that will > >return a single row and basically means a whole bunch of > >conditional SELECTs. You might need to explain more of what you're after; I don't understand this paragraph (sentence). -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>