Home > Articles

Using DB2 Functions

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

XML Publishing Built-in Functions

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.

  • + Share This
  • 🔖 Save To Your Account