Re: Please Help! Decode() in Informix??

Posted in 1999

Art S. Kagel — Wed, 14 Apr 1999 15:57:17 -0400 — source: Informix-list mailing list archive (1991-1998)

Alain C. Bonnemaison wrote: [SNIP] > In Oracle, there is a function called Decode() which allows the simulation > of an "If...Then...Else" statement. My knowledge of Informix is > unfortunately limited and the SQL reference books (Informix 7.1) I got make > no mention of such function. The decode functionality, along with UPPER, LOWER, NVL, and other useful Oracle-isms were added to IDS V7.30. So the solution is write SPL or upgrade. Art S. Kagel