User`s guide
uSgn
176 Sybase IQ ETL 4.1
uRound(10.9) // returns "11"
uRound(1.235, 2) // returns "1.24"
uSgn
Description Returns the sign of a given value
Syntax number uSgn(value)
Parameters
number value
A number to calculate on.
Examples To detecting the sign of a given value:
uSgn(-10.4) // returns -1
uSgn(0) // returns 0
uSgn(10.4) // returns 1
uSgn(null) // returns null
uSqrt
Description Returns the square root of a given value.
Syntax number uSqrt(value)
Parameters
number value
A number to calculate on.
Examples To calculate a square root:
uSqrt(25) // returns 5
uSqrt(0) // returns 0
uSqrt(null) // returns null