Numeric Functions

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.

CEILING
DECIMAL
FACTORIAL
FLOAT
FLOOR
INTEGER
MOD
PI
ROUND
SIGN
TRUNCATE
XABS
XEXP
XLN
XLOG
XPOWER
XSQRT