Articles & Content
Topic: Cross Platform DB2 for z/OS & LUW
DATE: 2006-5-8 (10:20 AM - 11:30 AM)
SPEAKERS: Matthias Nicola (IBM)
Relational data in DB2 often needs to be returned in XML format,eg. for web applications, application integration, or data exchange with internal and external parties. SQL/XML publishing functions have been introduced in DB2 V8.1, extended in DB2 V8.2, and are now also available in DB2 V8 for zOS. This tutorial explains SQL/XML publishing through a series of examples, and concludes with a live demo.
EXP. LEVEL: Beginner
XML on Demand: Publishing relational data as XML
SQL/XML Publishing Functions
SQL/XML usage in DB2 and Information Integrator
SQL/XML Queries that produce HTML
XMLELEMENT, XMLATTRIBUTES, XMLAGG
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.