Adapter Online Help
>
TDV DB2 Adapter
>
DB2 Function Support
>
DB2 Numeric Function Support
DB2 Numeric Function Support
TDV supports the numeric functions listed in the table below for DB2. DB2 does not support string-type arguments in numeric functions.
DB2 Numeric Function
Notes
ABS
ACOS
ASIN
ATAN
CEILING
COS
COT
DEGREES
EXP
FLOOR
LOG
PI
Not supported.
POW
Supported only for version 11.
POWER
RADIANS
RANDOM
ROUND
SIN
SQRT
TAN