ASIN
The ASIN function returns the arc sine of the argument as an angle, expressed in radians. The ASIN and SIN 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 except for DECFLOAT. The value must be greater than or equal to -1 and less than or equal to 1. 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.
The result is greater than or equal to -π/2 and less than or equal to π/2.
Example: Assume that host variable
ASINE is DECIMAL(10,9) with a value of 0.997494987. The following
statement:
SELECT ASIN(:ASINE)
FROM SYSIBM.SYSDUMMY1;
returns a double precision
floating-point number with an approximate value of 1.50.