Let's have some fun with date logic in our SQL statements.
There are a lot of practical SQLs for developer. We talk about pattern matching using regular expression, how to invoke external REST services using HTTPGETCLOB, and consuming the REST response in JSON and XML using the JSON or XML features in Db2 for z/OS.
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.