DB2 Developers Guide (5th Edition)

2017-07-07 02:10:07

< Day Day Up >

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.

< Day Day Up >

Категории