LOG

Returns the logarithm of a numeric value.

Most often, you use this function to analyze scientific data rather than business data.

Syntax

LOG( base, exponent )

Argument	Required/ Optional	Description
base	Required	The base of the logarithm. Must be a positive numeric value other than 0 or 1. Any valid expression that evaluates to a positive number other than 0 or 1.
exponent	Required	The exponent of the logarithm. Must be a positive numeric value greater than 0. Any valid expression that evaluates to a positive number greater than 0.

Return Value

Double value.

NULL if a value passed to the function is NULL.

Example

The following expression returns the logarithm for all values in the NUMBERS column:

LOG( BASE, EXPONENT )

BASE	EXPONENT	RETURN VALUE
15	1	0
.09	10	-0.956244644696599
NULL	18	NULL
35.78	NULL	NULL
-9	18	None. (Data Integration writes the row to the error rows file.)
0	5	None. (Data Integration writes the row to the error rows file.)
10	-2	None. (Data Integration writes the row to the error rows file.)

If you pass a negative number, 0, or 1 as a base value, or if you pass a negative value for the exponent, Data Integration writes the row to the error rows file.