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 • 14:00 - 14:45
Generate XML Documents with SQL (SQL and XML – Part 1)

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.
With Release 7.1 XML support is included into SQL and the database DB2 for i. Well-formed XML documents can be stored in columns defined with the new XML data type. Multiple scalar and aggregate functions are introduced for generating elements, attributes with or without name spaces and even complete XML documents solely with SQL. In composition with embedded SQL those XML documents can be created and directly written into the IFS with only a few statements. The focus of this session is to generate XML documents and write them either in SQL tables or directly into the IFS.

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. Those XML documents are either stored in a column in a SQL table or directly within the IFS. This session 170052.

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 14:00 - 14:45 CEST