Re: NULL value

Posted in 1998

Jonathan Leffler — Wed, 28 Oct 1998 22:18:30 -0800 — source: Informix-list mailing list archive (1991-1998)

Olcay Sarioglu wrote: > Is it possible to convert NULL to a default value? In Oracle you > can use NVL function: > select nvl(my_field, default_value_if_null) from my_table; > > Is there a corresponding function in Informix? As Rob said, you can write your own (though you'd need to use PROCEDURE instead of FUNCTION if your server is not in the IUS - IDS/UDO - 9.x family). If you have 7.30 IDS or later (within the 7.3x family), you can use the built-in NVL() function. Expect this to propagate to the other IDS products soon. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>