SIGN
(SIGN(
arg1
,
arg2
))
Transfers the sign of
arg2
to
arg1
.
Arg1
and
arg2
must be values that have DOUBLE, REAL, NUMERIC, or INTEGER data types.
In the following example, the value of
vsign
is
-15
, changing the sign of the first argument to the sign of the second argument.
SET VAR vsign = (SIGN(15,-20))