Loading…
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!

Tweet Share
Feedback Survey
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.
Speakers
avatar for Birgitta Hauser

Birgitta Hauser

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

Wednesday May 22, 2019 8:00am - 9:00am PDT
Fantasy Tower Magic Kingdom 4
  Database
  • 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