Attending this event?
Welcome to the Common Europe Congress 2023 agenda site.

Number of registered participants 
May 18th - 299
May 18th - 308
May 19th - 309
May 24th - 325
May 26th - 344

For more registration and information about our CEC, please go here:
Back To Schedule
Sunday, June 11 • 14:00 - 17:00
Generating and Consuming JSON with SQL

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

Abstract:   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 scalar and aggregate functions were integrated into SQL on Db2 for i, for generating JSON objects, arrays, literals and for combining JSON components into complete hierarchical JSON-documents. Since 7.5 TR 1 it is even possible to modify/update JSON Documents/Data
With the JSON_TABLE table function on the other hand 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.
Learning Objectives:
                 Get an introduction into JSON basics. Learn how JSON object and arrays can be generated, concatenated or nested and composed into JSON documents.
Discover how JSON documents located in either the IFS or a column of a table or JSON answers returned by web services can be parsed with the JSON_TABLE table function, converted into a relational representation and data specifically selected.
You’ll also get an overview over the new http-functions and how to use them for getting access to web services.
AudienceDevelopers and Users who are experienced in SQL Queries and want to create JSON data with SQL.
Developers and Users who need to process JSON documents located in either SQL tables or the IFS or JSON answers returned by web services.
Everybody who simply wants to enhance his SQL know-how.

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

Sunday June 11, 2023 14:00 - 17:00 CEST
05-Prague D
Feedback form isn't open yet.

Attendees (4)