The Db2 12 for z/OS pureXML Guide describes how to use the Db2 12 for z/OS pureXML feature.
This IBM publication is the pureXML Guide for Db2 12 for z/OS (product number 5650-DB2) and Db2 12 for z/OS Value Unit Edition (product number 5770-AF3), in the 2023-05-17 edition. It covers the pureXML data model, the XML data type, creating and altering tables with XML columns, the storage structure for XML data, insertion and updates of XML documents, deletion of rows, XML versions, triggers, parsing, and XML schema validation with an XML type modifier or DSN_XMLVALIDATE.
Later chapters cover XML data indexing with pattern expressions and access methods, XML support in Db2 utilities, XML schema registration and removal through the XML schema repository (XSR), XML data in Java, embedded SQL and ODBC applications, XML data encoding and CCSID mappings, and XQuery, including its type system, prologs and expressions, and descriptions of XQuery functions.
| Product | Db2 12 for z/OS |
|---|---|
| Product number | 5650-DB2 |
| Value Unit Edition product number | 5770-AF3 |
| Publication number | SC27-8862-02 |
| Edition date | 2023-05-17 |
It applies to Db2 12 for z/OS (product number 5650-DB2) and Db2 12 for z/OS Value Unit Edition (product number 5770-AF3), and to any subsequent releases until otherwise indicated.
It describes XML schema validation, including validation with an XML type modifier, validation with DSN_XMLVALIDATE, and how to determine whether an XML document has been validated.
It covers pattern expressions, namespace declarations in XML index definitions, the UNIQUE keyword in an XML index definition, and access methods with XML indexes.
Subsequent editions are not delivered in the IBM Publications Center; the latest edition should always be downloaded from IBM Documentation.