Re: Equivalent Oracle functions in Db2
From: Martin Heyerdahl Smevik <heyers_at_online.no>
Date: 2000/07/19
Message-ID: <8l47g9$2hd$1_at_oslo-nntp.eunet.no>#1/1
Date: 2000/07/19
Message-ID: <8l47g9$2hd$1_at_oslo-nntp.eunet.no>#1/1
"Fernando Agudo" <fagudo_at_fplanet.es> wrote in message
news:39755878.11AE7896_at_fplanet.es...
> I would like to know which is the equivalent for NVL and DECODE Oracle
> functions in Db2, Where could i find a function mapping table between
> Oracle and Db2?
>
> Thanks a lot
>
The DB2 equivalent for NVL is VALUE.
VALUE(column1, <replacement value>), ....i.e VALUE(birth_date, '20000719')
I can't remember the DB2 equivalent for DECODE, sorry....
- martin