LN
The LN function returns the natural logarithm of the argument. The LN and EXP functions are inverse operations.
The schema is SYSIBM.
The argument must be an expression that returns the value of any built-in numeric data type that is not DECFLOAT. If the argument is not a double precision floating-point number, it is converted to one for processing by the function.
The result of the function is a double precision floating-point number.
The result can be null; if the argument is null, the result is the null value.
LOG is a synonym for LN.
Example: Assume
that host variable NATLOG is DECIMAL(4,2) with a value of 31.62. The
following statement returns a double precision floating-point number
with an approximate value of 3.45:
SELECT LN(:NATLOG)
FROM SYSIBM.SYSDUMMY1;