Returns the arccosine of the argument as an angle expressed in radians.

The schema is SYSIBM. (The SYSFUN version of the ACOS function continues to be available.)

expression

An expression that returns a value of any built-in numeric data type except for DECFLOAT.
The value is converted to a double-precision floating-point number 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 can be null or the database is configured with dft_sqlmathwarn set to YES; the result is the null value if the argument is null.

Example

Assume that the host variable ACOSINE is a DECIMAL(10,9) host variable with a value of 0.070737202.

         SELECT ACOS(:ACOSINE)
         FROM   SYSIBM.SYSDUMMY1

This statement returns the approximate value 1.49.