Common Sweden Conference 2024

JSON becomes more and more important especially in RESTful web services the, use of XML declines in favor of JSON.
With the JSON_TABLE table function JSON documents can be parsed, converted into a relational representation and data picked specifically out.
Additional scalar functions allow SQL to directly access JSON documents located within the IFS (Integrated File System) or in source physical file members. Last but not least IBM provides SQL functions for getting access to web services. In composition with the JSON_TABLE function the JSON responses returned by web services can be consumed