Chapter 7. Querying XML Data with SQL/XML

The SQL language standard includes a variety of functions and features to process XML data. This functionality is commonly referred to as SQL/XML. The SQL/XML functions that allow you to embed XPath and XQuery expressions in SQL are of particular interest. These functions enable you to use familiar SQL statements enriched with XPath expressions to query XML data in a DB2 database. They also facilitate the simultaneous processing of XML and relational data in the same query. This marriage of two worlds, XML and relational, is extremely powerful and versatile.

Although SQL/XML allows the integration of SQL and XQuery, this chapter focuses on the integration of SQL and XPath, which is supported ...

Get DB2 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.