This event has ended. Visit the official site or create your own event on Sched.
View analytic
Tuesday, June 20 • 08:00 - 09:00
Consuming JSON with SQL

Sign up or log in to save this to your schedule and see who's attending!

Feedback form is now closed.
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.

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... Read More →

Tuesday June 20, 2017 08:00 - 09:00
ROOM 15/16/17

Attendees (21)