Hi,
Im converting an oracle sql statement to db2 and we use the oracle's log function with the base 2 as an argument , in db2 the log function uses the base log or 10 as argument . my question is how can i use the base 2 (or pass the base as argument) in db2?
10x

In general

log a (base x) = log a (base z)/ log x (base z)

Applying this to convert log base 2 to base 10

log a (base 2) = 3.32 x log a (base 10)

HTH

Sathyaram

10x a lot
i used this
CREATE FUNCTION LOG2(value float)
returns float
LANGUAGE SQL
DETERMINISTIC
NO EXTERNAL ACTION
CONTAINS SQL
return ln(value)/ln(2)@