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 |