As per the DB2 Day in London on Monday JSON support MAY be coming in Fixpack 4.
At the DB2 Day in London George Baklarz mentioned that Morgan Stanley are giving a talk on the new JSON feature as IDUG NA 2018, as Early Access Preview people when are we getting access to this?
Morgan Stanley actually was discussing their use of the "proprietary" JSON functions we started revealing around the time that Db2 11.1 GA'd and then documented (SQL access to JSON documents https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.swg.im.dbclient.json.doc/doc/c0070285.html) in Db2 188.8.131.52. It is an interesting perspective on both their journey from XML through to the initial JSON functions offered today in Db2 11.1 (and Db2 10.5). They also point out some of the warts and shortcomings of these functions :(
The new JSON SQL functions that George was mentioning are actually brand-new implementations based upon the recent ISO JSON SQL proposals and we will indeed begin to deliver some of them into Db2 11.1... in fact, a couple of them are already in this latest beta drop (s1805160100) but we didn't announce them as we wanted to get a bit further along before revealing them.
Since it's just you and I here ;), I will tell you about the ones in this latest drop:
The first four are fully implemented, the last one is an initial implementation that has some limitations in its abilities.
My hope is to get a couple more key ones in place, at least initial implementations before the next drop and then we will reveal them along with some documentation to help use them.
If you are interested in trying the ones above out, warts and all, send me an email and I will put together a small set of documentation on what they offer.
If not, check back in next month to see if we made our goal and announce the new ISO JSON SQL support officially! :)
Thanks for your interest in Db2 and JSON,