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.
We are getting back on track how to access and manipulate XML documents in DB2 for z/OS. But this time, with focus on more complex XML data manipulation techniques than just selecting/inserting/updating, or deleting the whole XML document.
In Part 2, we will examine how to exploit Application Compatibility (APPLCOMPAT) which was introduced in DB2 11, and Function Levels which is introduced in DB2 12 to safely manage change. The levels of APPLCOMAT you can specify is limited by the Function Level of your system.
With the current interest in DevOps, a renewed focus on streamlining database change and integrating it with associated application change has been evident in recent times.In this paper we will look at one part of the overall topic of agile database development – the concept of database refactoring.
When you exchange XML documents between different systems or applications, you may need a construct that ensures your applications will “understand” the XML documents that are being exchanged. And this is where XML schema comes into a play!
International DB2 Users Group
330 North Wabash, Suite 2000 | Chicago, IL 60611-4267
Phone: (312) 321-6881 | Fax: (312) 673-6688