User`s guide

uAbs
172 Sybase IQ ETL 4.1
Numeric functions
uAbs
Description Returns the magnitude of a real number, ignoring its positive or negative sign.
Note This function can only calculate with numbers. In all other cases, it
returns zero.
Syntax number uAbs(value)
Parameters
number value
A number to calculate on.
Examples To calculate the absolute value:
uAbs(1522) // returns 1522
uAbs(‘-123.45’) // returns 123.45
uAbs(‘123ABC’) // returns 0
uCeil
Description Returns the least integer greater than or equal to argument.
Syntax number uCeil(value);
Parameters
number value
A number to calculate on.
Examples To round up numbers:
uCeil(1523.1) // returns 1524
uCeil(1522.9) // returns 1524