The ABS function returns the absolute value of a number.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
Results involving
DECFLOAT special values: For decimal floating-point values, the
special values are treated as follows:
Syntax alternatives: ABSVAL is a synonym for ABS. It is supported only for compatibility with previous DB2® releases.
SELECT ABS(:PROFIT) FROM SYSIBM.SYSDUMMY1Returns the value 50000.