IBM Books

XML Extender Administration and Programming


Extracting functions

The extracting functions extract the element content or attribute value from an XML document and return the requested SQL data types. The XML Extender provides a set of extracting functions for various SQL data types. The extracting functions take two input parameters. The first parameter is the XML Extender UDT, which can be one of the XML UDTs. The second parameter is the location path that specifies the XML element or attribute. Each extracting function returns the value or content that is specified by the location path.

Because some element or attribute values have multiple occurrence, the extracting functions return either a scalar or a table value; the latter is called the table function.

The XML Extender provides the following extracting functions:

The examples in the following section assume you are using the DB2 command shell, in which you do not need to type "DB2" at the beginning of each command.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]