for WMCPA Spring Conference 2017
Attending this event?
View analytic
Thursday, March 16 • 4:15pm - 5:45pm
Consuming JSON Documents and Web Services with SQL

Log in to save this to your schedule and see who's attending!

 XML and JSON become more and more important for data exchange especially when using web services. While XML was supported by SQL since Release 7.1, access to JASON documents is not introduced before 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 functions for getting access to web services. In composition with the JSON_TABLE function the JASON answers returned by web services can be consumed.

Learning Objectives:
Learn how JSON documents located in either the IFS or an XML column or JSON answers from 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.

Audience: Developers and Users who are experienced in SQL Queries and need to process JSON documents located in either SQL tables or the IFS or JSON answers returned by web services or simply want to enhance their SQL know-how.

Level: Advanced

Duration: Single Session

avatar for Birgitta Hauser

Birgitta Hauser

Software and Database Engineer, Toolmaker Advanced Efficiency GmbH
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works in consulting and education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences... Read More →

Thursday March 16, 2017 4:15pm - 5:45pm
Geneva 2