Loading…
Back To Schedule
Tuesday, October 5 • 8:00am - 9:00am
Generating JSON Documents with SQL (SQL and JSON – Part 1)

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

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. _x000D_ 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 focus of this session is to generate JSON documents.

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.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect
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 →


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 7 Online
  Database

Attendees (1)