Re: Oracle NVL equivalent ?

Clem Akins wrote: > Peter inquires: > > We are currently porting one of our applications to > >unix/informix HP 9.04/online 6 from NT/Oracle 7 > > That is an ancient version of Informix. OnLine version 6 is currently > in Limited Maintenance mode and scheduled to go to Time & Materials > at the end of '97. (See the Informix web site at http://www.informix.com > in the techinfo center. You must have a paid-for support contract.) > Beware of the limitations of such an old version. > > >We currently use NVL to return a value (0) in place of a null in a > >select statement. Is there any equivalent in Informix? > > There is an exact Oracle equivalent scheduled in version 7.3, available > in the Spring of '98, and no supported equivalent prior to that. > > You can search the archives of the comp.databases.informix newsgroup > for discussions of this feature. (One way is via the International > Informix Users Group at http://www.iiug.org .) > > ___________________________________________________________ > Clem Akins (aka clem@informix.com) > Informix Software, Inc (Standard disclaimers apply) > International Technical Support > Last seen: Learning more about 7.3 in Menlo Park, CA, USA And what about INFORMIX Universal Server? Will that also include an equivalent to the NVL function? Avi. ************************************************************************ /\\ \\ /| Avi Abrami, Analyst/Programmer, Telegate Ltd. /__\\ \\ / | 7 Haplada Street, Or-Yehuda, ISRAEL / \\ \\/ | Phone:+972-3-5388717 Fax:+972-3-5335877 eMail:avia@telegate.co.il