DB2 Character Function | Notes |
BTRIM | Supported only for version 11. |
CONCAT | LONGVARCHAR not supported. |
LEFT | Supported only for version 11. |
LENGTH | |
LOWER | |
POSITION | |
REGEXP_REPLACE | Supported only for version 11. |
REPLACE | |
RIGHT | Supported only for version 11. |
RTRIM | |
SPACE | SMALLINT and INTEGER arguments only. |
STRPOS | Supported only for version 11. |
SUBSTRING | |
TRIM | |
UPPER |