As Db2 becomes a better database for the implementation of hybrid datastores, we're starting to see support for JSON become more substantial.
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.
Using JSON is a lot easier than using XML. Manually editing a document is much more manageable and adjusting the structure is quick and easy. It is also easier to create an invalid JSON document without knowing it.
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 asked many times.
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.