This event has ended. Visit the official site or create your own event on Sched.

Talarna lägger upp sessionerna själva och vi har påminnt dem om att göra det. 
Saknar ni någon kontakta gärna talarna direkt själva eller maila styrelsen.

Back To Schedule
Tuesday, October 17 • 15:00 - 15:45
Consume XML Documents and Web Services with SQL (SQL and XML – Part2)

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Abstract: The XML support included in SQL and DB2 for i with Release 7.1 does not only allow XML
documents to be generated, but also allow XML documents to be consumed. Annotated XML
Document Decomposition is a SQL stored procedures that shreds XML documents based on
registered XML schemas directly into database tables. With the XMLTABLE table function
XML documents can be parsed, converted into a relational representation and data picked
specifically out. Additional scalar functions allow SQL to directly access XML documents
located within the IFS (Integrated File System) or in source physical file members. Last but
not least new SQL functions for getting access to web services are introduced. In
composition with the XMLTABLE function the XML answers returned by web services can be
consumed. The focus of this session is parsing XML documents located in either SQL tables
or within the IFS or returned by web services.
Learning Objectives:
Learn how well-formed XML documents located in either the IFS or an XML column can be
parsed with the XMLTABLE 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 XML
documents located in either SQL tables or the IFS or look for an easy way to access web
services or simply want to enhance their SQL know-how.

avatar for Birgitta Hauser

Birgitta Hauser

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

Tuesday October 17, 2017 15:00 - 15:45 CEST