Function
| DB2 for
i5/OS 1
| DB2 for LUW
| DB2 for
z/OS 1
|
---|---|---|---|
ABS()
| No
| Yes
| No
|
ADD_TO_DATE()
| Yes
| Yes
| Yes
|
ASCII()
| Yes
| Yes
| Yes
|
AVG()
| Yes
| Yes
| Yes
|
CEIL()
| Yes
| Yes
| Yes
|
CHR()
| No
| Yes
| No
|
CHRCODE()
| No
| Yes
| Yes
|
CONCAT()
| Yes
| Yes
| Yes
|
COS()
| Yes
| Yes
| Yes
|
COSH()
| Yes
| Yes
| Yes
|
COUNT()
| Yes
| Yes
| Yes
|
DATE_COMPARE()
| Yes
| Yes
| Yes
|
DECODE()
| No
| Yes
| No
|
EXP()
| No
| Yes
| No
|
FLOOR()
| No
| Yes
| No
|
GET_DATE_PART()
| Yes
| Yes
| Yes
|
IIF()
| No
| Yes
| No
|
IN()
| No
| Yes
| No
|
INSTR()
| Yes
| Yes
| Yes
|
ISNULL()
| Yes
| Yes
| Yes
|
LENGTH()
| Yes
| Yes
| Yes
|
LN()
| Yes
| Yes
| Yes
|
LOG()
| Yes
| Yes
| Yes
|
LOWER()
| Yes
| Yes
| Yes
|
LTRIM()
| Yes
| Yes
| Yes
|
MAX()
| Yes
| Yes
| Yes
|
MIN()
| Yes
| Yes
| Yes
|
MOD()
| Yes
| Yes
| Yes
|
POWER()
| Yes
| Yes
| Yes
|
ROUND(DATE)
| No
| No
| Yes
|
ROUND(NUMBER)
| Yes
| Yes
| Yes
|
RTRIM()
| Yes
| Yes
| Yes
|
SIGN()
| Yes
| Yes
| Yes
|
SIN()
| Yes
| Yes
| Yes
|
SINH()
| Yes
| Yes
| Yes
|
SOUNDEX()
| No
| Yes 1
| No
|
SQRT()
| No
| Yes
| No
|
STDDEV()
| Yes
| Yes
| Yes
|
SUBSTR()
| Yes
| Yes
| Yes
|
SUM()
| Yes
| Yes
| Yes
|
SYSTIMESTAMP()
| Yes
| Yes
| Yes
|
TAN()
| Yes
| Yes
| Yes
|
TANH()
| Yes
| Yes
| Yes
|
TO_BIGINT
| Yes
| Yes
| Yes
|
TO_CHAR(DATE)
| Yes
| Yes
| Yes
|
TO_CHAR(NUMBER)
| Yes
| Yes2
| Yes
|
TO_DATE()
| Yes
| Yes
| Yes
|
TO_DECIMAL()
| Yes
| Yes3
| Yes
|
TO_FLOAT()
| Yes
| Yes
| Yes
|
TO_INTEGER()
| Yes
| Yes
| Yes
|
TRUNC(NUMBER)
| Yes
| Yes
| Yes
|
UPPER()
| Yes
| Yes
| Yes
|
VARIANCE()
| Yes
| Yes
| Yes
|