SQL XML programming

DB2® for IBM® i provides support to store and retrieve XML data using Structured Query Language (SQL). Objects defined using SQL such as tables, functions, and procedures can use the XML data type for column, parameter, and variable definitions. In addition to an XML data type, there are built-in functions and procedures that can be used to generate XML documents and to retrieve all or part of an XML document.

Note: By using the code examples, you agree to the terms of the Code license and disclaimer information.

How to read the syntax diagrams
The following rules apply to the syntax diagrams used in this book.
PDF file for SQL XML programming
You can view and print a PDF file of this information.
SQL statements and SQL/XML functions
Many SQL statements support the XML data type. This enables you to perform many common database operations with XML data, such as creating tables with XML columns, adding XML columns to existing tables, creating triggers on tables with XML columns, and inserting, updating, or deleting XML documents. A set of SQL/XML functions, expressions, and specifications supported by DB2 database server takes full advantage of the XML data type.
Annotated XML schema decomposition
Annotated XML schema decomposition, also referred to as "decomposition" or "shredding," is the process of storing content from an XML document in columns of relational tables. Annotated XML schema decomposition operates based on annotations specified in an XML schema. After an XML document is decomposed, the inserted data has the SQL data type of the column that it is inserted into.
XML data model
The XML data model follows the XPath 2.0 and the XQuery 1.0 data model. This data model provides an abstract representation of one or more XML documents or fragments.
Overview of XPath
XPath is an expression language that was designed by the World Wide Web Consortium (W3C) to allow processing of XML data that conforms to the XQuery 1.0 and XPath 2.0 data model. XQuery is a functional programming language that was designed by the World Wide Web Consortium (W3C) to meet specific requirements for querying and modifying XML data. DB2 XPath supports a subset of the language constructs in the XPath 2.0 recommendation.