Common Sweden Conference 2024

JSON (Java Script Online Notation) is a data exchange format like XML, however JSON is simpler, less verbose and can be faster parsed than XML. In this way JSON becomes more and more important especially when data is exchanged by RESTful web services. The use of XML declines in favor of JSON. SQL on Db2 for i includes all kinds of scalar and aggregate functions for generating JSON objects, arrays, literals and for combining JSON components into complete documents. Since Release 7.5 TR 1 it is even possible to update/modify JSON documents. The focus of this session is to generate JSON documents.