The SQRT function returns the square root of a number.

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

expression

An expression that returns a value of any built-in numeric data type.
If the argument is decimal floating-point, the operation is performed in decimal floating-point; otherwise, the argument is converted to double-precision floating-point for processing by the function.

If the argument is DECFLOAT(n), the result is DECFLOAT(n); otherwise, the result is a double-precision floating-point number.

The result can be null; if the argument is null, the result is the null value.

Notes

• Results involving DECFLOAT special values: If the argument is a special decimal floating-point value, the rules for general arithmetic operations for decimal floating-point apply.
  See General arithmetic operation rules for decimal floating-point in Expressions.

Example

Assume that SQUARE is a DECIMAL(2,1) host variable with a value of 9.0.

   VALUES SQRT(:SQUARE)