Restriction: This topic applies to Windows environments only.
These functions can be used any place a numeric value is required. The parameters
x and
y can be any expression that evaluates to a number. Money fields can only be used in the FLOAT, INTEGER or XABS functions.
The operators
+,
-,
/, and
* are also available. In DB2 mode, integer division (/) results in an integer with decimal places truncated.
Note: DB2 truncates expression results. The XDB Server rounds. For example, if result type is 5,2 and expression value is 123.555,
DB2 mode retrieves 123.55 while XDB mode retrieves 123.56.
More:
-
CEILING
-
DECIMAL
-
FACTORIAL
-
FLOAT
-
FLOOR
-
INTEGER
-
MOD
-
PI
-
ROUND
-
SIGN
-
TRUNCATE
-
XABS
-
XEXP
-
XLN
-
XLOG
-
XPOWER
-
XSQRT