Decode
Renata asked whether Informix 7.2 has a function like Oracle's DECODE. Peter J Diaz de Leon thought DECODE arrived in 7.3x and suggested upgrading or checking IIUG for SPL equivalents. Uwe Weber confirmed DECODE is available in IDS 7.30. Don Hanson suggested the orclproc archive from IIUG, which holds Oracle-equivalent procedures. No 7.2 built-in was identified.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All, Is there any similar function like "decode" in oracle for Informix 7.2? Thank you, Renata
On 23 Sep 1999 04:20:52 GMT, "Renata" <renata@csah.com> wrote: >Hi All, > >Is there any similar function like "decode" in oracle for Informix 7.2? > >Thank you, >Renata I believe the DECODE function became available in 7.3x. You will need to upgrade. You also might want to check the IIUG archives. I thought I saw some SPL's that imlemented some of this missing functionality. -Peter
Renata wrote: > > Hi All, > > Is there any similar function like "decode" in oracle for Informix 7.2? > > Thank you, > Renata No! "decode" is available for IDS 7.30 -- Uwe Weber Trainer Central Europe Informix Software Oskar-Messter-Strasse 22 Tel.: +49-(0)89-99613-890 D-85737 Ismaning FAX.: +49-(0)89-99613-880
Try downloading the orclproc archive from IIUG. it contains a number of oracle equiv. procedures. Don Hanson Renata wrote: > Hi All, > > Is there any similar function like "decode" in oracle for Informix 7.2? > > Thank you, > Renata