SGN |
sgn returns the sign of a numeric parameter.
sgn(num_exp)
|
Element |
Description |
Restrictions |
|
num_exp |
Numeric Expression |
None |
CUBIC_ROOT = sgn(X) * abs(X) ^ (1/3)
sgn(X) returns:
+1 if X is positive,
0 if X is null,
-1 if X is strictly negative.
The result is of the Integer data type.
|
Error |
Description |
|
ERMODE (10) |
The parameter is not numeric. |
|
|