Start of change

Decomposing XML documents with annotated XML schemas

When you want to store pieces of an XML document in columns of one or more tables, you can use annotated XML schema decomposition. This type of decomposition breaks an XML document down for storage in tables, based on the annotations specified in a registered annotated XML schema.

To decompose XML documents using annotated XML schemas:

  1. Annotate the schema documents with XML decomposition annotations.
  2. Register the schema documents and enable the schema for decomposition.
  3. If any of the registered schema documents that belong to the XML schema have changed, then all XML schema documents for this XML schema must be registered again and the XML schema must be enabled for decomposition again.
  4. Decompose the XML document by calling the SYSPROC.XDBDECOMPXML stored procedure.
Parent topic: Annotated XML schema decomposition
End of change