Welcome to Common Europe Congress 2019 in Berlin!
Back To Schedule
Sunday, June 16 • 10:00 - 13:00
Generating and Consuming JSON Data

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
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. With Release 7.3 TR 3 a bunch of scalar and aggregate functions were integrated into SQL, for generating JSON objects, arrays and for combining JSON components into complete documents. The JSON_TABLE tables function for consuming JSON data was already introduced with Release 7.3 TR 1. 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 http-functions for getting access to web services. In composition with the JSON_TABLE function the JSON answers returned by web services can be consumed within a SELECT-Statement.

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect

Sunday June 16, 2019 10:00 - 13:00 CEST

Attendees (6)