In our connected world, we send and receive messages with other businesses using different formats. One message format, JSON, is relatively new to the mainframe. This presentation will discuss ways to work with JSON documents using SQL functions. The emphasis is on building, storing, and parsing...
In the recent customers’ conference calls, a lot of customers are confused about Db2 for z/OS JSON capability and Native REST services. They think they are the same thing. In fact, they are completely different. In this article, I will describe the difference and share the questions I have been...
With decade’s development of Db2 for z/OS, it provides a lot of wonderful features in each release. Among these features, some of them are extremely useful but less “well-known”. Pattern matching using regular expression is one of these hidden gems. In the following sections, I will give a...
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. We will also present the JSON enhancements we delivered in the...
It is pretty clear that one of the key technologies of the moment is JSON. And this is reflected in many of the latest advances associated with DB2. Among the JSON-related developments in the DB2 space we have seen the RESTful web service support in DB2 for z/OS, the IBM Data Server Gateway for...
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. Tips and pitfalls will be shared to ensure a successful JSON...
DB2 for z/OS NoSQL Support Update: REST and JSON Daniel Luksetich, DanL Database consulting danl@db2expert.com The DB2 landscape is changing quickly, and sometimes things can quietly sneak in before you even realize it. Maybe you have heard IBMers talking about JSON support in DB2,...
September 2014 eBulletin
IDUG_September_eBulletin.pdf
As I sit here on the last day of my summer vacation overlooking nature and holding a Jack on the rocks, determined to write this article, I can’t help but think: “wow times goes by fast.” I was going to write this article the first day, no wait the second... well you know the story. But that did...
1 Comment - no search term matches found in comments.
DB2 has had best of breed XML support for a number of years. However many web applications now rely on the (supposedly) simpler JSON for sending and receiving data. This presentation looks at how DB2 itself is changing to accomodate this trend, and how we can handle JSON in DB2 today by...
EU13D03.pdf