Articles & Content

Archives

Publishing relational data as XML (D01)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2006



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

OBJECTIVES:

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.