Retrieving XML data

You can retrieve entire XML documents from XML columns by using an SQL SELECT statement. Alternatively, you can use SQL with XML extensions (SQL/XML) to retrieve portions of documents.

The SQL/XML functions that supports retrieval of portions of XML documents are XMLQUERY and XMLTABLE. To filter table rows by XML document content, use the SQL/XML XMLEXISTS predicate.

Retrieval of an entire XML document from an XML column
Retrieval of an entire XML document from an XML column is similar to retrieval of a value from a LOB column.
XMLQUERY function for retrieval of portions of an XML document
XMLQUERY is an SQL scalar function that lets you execute an XQuery expression from within an SQL context.
XMLEXISTS predicate for querying XML data
The XMLEXISTS predicate can be used to restrict the set of rows that a query returns, based on the values in XML columns.
Constant and parameter marker passing to XMLEXISTS and XMLQUERY
You can specify XQuery variables as part of the XQuery expression in the XMLEXISTS predicate and the XMLQUERY function.
XMLTABLE function for returning XQuery results as a table
The XMLTABLE SQL/XML function returns a table from the evaluation of XQuery expressions.
XML support in native SQL routines
Native SQL routines support parameters and variables with the XML data type.
Requests for data in XML columns by earlier DB2 clients
If you retrieve data from an XML column to a client that is at an earlier release than DB2 9, your database client cannot handle XML data.

Parent topic: Working with XML data

Related concepts:

XML serialization