IBM InfoSphere DataStage, Version 11.3.1
ABS function
Syntax
ABS (expression)
Description
Use the ABS function to return the absolute value of any numeric expression. The absolute value of an expression is its unsigned magnitude. If expression is negative, the value returned is:
-expression
For example, the absolute value of -6 is 6.
If expression is positive, the value of expression is returned. If expression evaluates to the null value, null is returned.
Example
Y = 100
X = ABS(43-Y)
PRINT X
This is the program output:
57
Last updated: 2015-03-09
PDF version of this information: