SQRT scalar function

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

   VALUES SQRT(:SQUARE)