Developer Mapping Guide

Back Next

Functions for IBM DB2

Informatica functions are not available for non-relational sources on

z/OS

. The following table displays the Informatica functions available for pushdown optimization for IBM DB2 sources:

Function	DB2 for i5/OS ¹	DB2 for LUW	DB2 for z/OS ¹
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¹	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	Yes²	Yes
TO_DATE()	Yes	Yes	Yes
TO_DECIMAL()	Yes	Yes³	Yes
TO_FLOAT()	Yes	Yes	Yes
TO_INTEGER()	Yes	Yes	Yes
TRUNC(NUMBER)	Yes	Yes	Yes
UPPER()	Yes	Yes	Yes
VARIANCE()	Yes	Yes	Yes

If a function is not listed, the Integration Service cannot push that function to any database.