Db2 (On Premises and Cloud)

Expand all | Collapse all

Fixpack 4 betas?

  • 1.  Fixpack 4 betas?

    Posted 30 days ago

    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? 

     

    Regards,
    David.



  • 2.  RE: Fixpack 4 betas?

    Posted 30 days ago

    Hi David,

     

    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 11.1.2.2. 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:

    • SYSIBM.BSON_TO_JSON  
      • Convert BSON formatted document into JSON strings
    • SYSIBM.JSON_TO_BSON 
      • Convert JSON strings into a BSON document format
    • SYSIBM.JSON_ARRAY
      • Creates JSON array from input key value pairs
    • SYSIBM.JSON_OBJECT
      • Creates JSON object from input key value pairs
    • SYSIBM.JSON_VALUE
      • Extract an SQL scalar value from a JSON object

    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,

     

    Paul