XML and JSON support the storage of complex data structures. Standardizing your structures requires using a formal schema.
Applications around Mobile devices are becoming increasingly important in large enterprises with requirement of storing JSON in database. This presentation will illustrate the JSON storage model and SQL APIs to manipulate JSON data.
Today we will introduce the XQuery language and cover a basic subset of this language, including constructor and FLWOR expressions. Both expressions will be useful in SQL/XML functions in DB2 for z/OS.
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.
Fast INSERT performance speeds the way to getting new data into DB2, for ETL, bulk ingest jobs, and even just day-to-day transactions. In this new blog entry, we look at several helpful tips for making INSERT run as quickly as possible.