Loading…
Attending this event?
Monday, April 6 • 2:00pm - 6:15pm
DEEP DIVE: Part 1 − Generating and Consuming XML with SQL & Part 2 − Generating and Consuming JSON Documents with SQL (Workshop)

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

DEEP DIVE: Part 1 − Generating and Consuming XML with SQL (Workshop)
Level: Advanced
With Release 7.1, XML support is included in SQL and the DB2 for i database. Multiple scalar and aggregate functions are introduced for generating elements, attributes with or without name spaces, and even complete XML documents, solely with SQL. XML support also includes two methods for consuming XML data. Annotated XML Document Decomposition allows XML documents to be shredded directly into database tables based on registered XML schemas. With the XMLTABLE table function, XML documents can be parsed, converted into a relational representation, and data picked specifically out. Additionally, SQL includes multiple http-functions for accessing web services. Using these http-functions in combination with the XMLTABLE table functions, XML data returned from web services can be directly consumed within a SELECT-Statement.

Learning Objectives:
  • Get an introduction into XML basics.
  • Learn how XML elements and attributes can be generated, concatenated, or nested and composed into XML documents.
  • Discover how well-formed XML documents located in either the IFS or an XML column or returned by a web service can be parsed with the XMLTABLE table function, converted into a relational representation, and data specifically selected.
  • You’ll also get an overview of the 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 create and consume XML documents located in either SQL Tables or in an IFS file. Developers and users who want to access web services and consume the returned XML answers. Everybody who simply wants to enhance his SQL know-how.
 
Part 2 − Generating and Consuming JSON Documents with SQL (Workshop)
 JSON (Java Script Online Notation) is a data exchange format like XML, however JSON is simpler, less verbose, and can be parsed faster than XML. 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, scalar and aggregate functions were integrated into SQL for generating JSON objects, arrays, and for combining JSON components into complete documents.

The JSON_TABLE tables function for consuming JSON data was introduced with 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. 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 http-functions for getting access to web services. In combination with the JSON_TABLE function, the JSON answers returned by web services can be consumed within a SELECT-Statement.

Learning Objectives:
  • Get an introduction into JSON basics. Learn how JSON objects and arrays can be generated, concatenated, or nested and composed into JSON documents.
  • Discover how JSON documents, located in either the IFS or a column of a table or JSON answers returned by 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 of  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 want to create JSON data with SQL. Developers and users who need to process JSON documents located in either SQL tables or the IFS or JSON answers returned by web services. Everybody who simply wants to enhance his SQL know-how.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

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


Monday April 6, 2020 2:00pm - 6:15pm
(E) Ashland
Feedback form isn't open yet.

Attendees (1)