DB2 11.1 for LUW introduced built-in SQL functions for regular expressions, a long-awaited enhancement that effectively supersedes a couple of popular workarounds for regex processing in DB2 SQL. This article describes the REGEXP functions and explains what makes them better than older workarounds.
DB2 10.1 and 10.5 offer new and improved SQL features, many of which can benefit existing DB2 LUW applications without disrupting their design. This article highlights some relatively approachable SQL enhancements that, once adopted, could at least simplify if not accelerate older DB2 applications.
Even though DB2 has a very extensive list of built-in functions these functions may not be enough to satisfy a given requirement. In these situations all is not lost. Anyone can incorporate any needed functionality into the database via user-defined functions (UDFs).