In DB2® Version 10.1
Fix Pack 2 and later fix packs, some scalar functions are enhanced
to increase DB2 compatibility.
- LTRIM
- The LTRIM function now has an optional second parameter that can
be used to specify which characters are to be removed from the beginning
of a string. In earlier releases only blanks could be removed.
- MOD
- A SYSIBM version of the MOD function supports all of the SQL numeric
data types (not just the integer types). The existing SYSFUN version
of the function is still available
- RTRIM
- The RTRIM function now has an optional second parameter that can
be used to specify which characters are to be removed from the end
of a string. In earlier releases only blanks could be removed.