POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Wednesday, May 22 • 8:00am - 9:00am
41BP Generating JSON Documents with SQL

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. 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.

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect

Wednesday May 22, 2019 8:00am - 9:00am PDT
Fantasy Tower Magic Kingdom 4
  • Focused Education Roadmap SQL Programming
  • Level Advanced
  • AWARD Silver
  • Operating System IBM i
  • Audience Developers and users who are experienced in SQL Queries and need to create JSON documents for data exchange. Everybody who wants to enhance his SQL know-how