Adapter Online Help > TDV DB2 Adapter > DB2 Mainframe Function Support > DB2 Mainframe Character Function Support
 
DB2 Mainframe Character Function Support
TDV supports the character functions listed in the table below for DB2 Mainframe.
DB2 Mainframe Character Function
Notes
CONCAT
LONGVARCHAR not supported.
LENGTH
 
LOWER
 
POSITION
String-type arguments only.
REPLACE
 
RTRIM
 
SPACE
SMALLINT and INTEGER arguments only.
SUBSTRING
 
TRIM
 
UPPER
 
SUBSTR
 
ASCII
 
INSERT
 
LPAD
Result differs between pushed and not pushed. When pushed, the length argument will not accept non-constant value.
RPAD
Result differs between pushed and not pushed. When pushed, the length argument will not accept non-constant value.
DIFFERENCE
 
TRIM
 
REPEAT