DB2 Version 8 adds a number of new built-in scalar functions to allow applications to efficiently generate XML data from DB2 data. The XML publishing functions are
XMLELEMENT
Returns an XML element given an element name , an optional collection of attributes, and zero or more arguments that make up the contents of the element.
XMLATTRIBUTES
Used within the XMLELEMENT function to specify attributes of the XML element.
XMLFOREST
Returns a forest of XML elements that share a pattern from a list of expressions.
XMLCONCAT
Returns a forest of XML elements generated from a concatenation of two or more elements.
XMLAGG
Returns a concatenation of XML elements generated from a collection of XML elements.
XML2CLOB
Returns a CLOB representation of an XML expression.