An XML collection is a set of relational tables that contain data that is mapped to XML documents. This access and storage method lets you compose an XML document from existing data, decompose an XML document, and use XML as an interchange method.
The relational tables can be new tables that the XML Extender generates when decomposing XML documents, or existing tables that have data that is to be used with the XML Extender to generate XML documents for your applications. Column data in these tables does not contain XML tags; it contains the content and values that are associated with elements and attributes, respectively. Stored procedures act as the access and storage method for storing, retrieving, updating, searching, and deleting XML collection data.
See the following sections for information on managing your XML collection:
The XML Extender stored procedure syntax uses the parameter
UDB_SIZE to specify the size of certain character parameters.
The value of UDB_SIZE is determined by the version of DB2 UDB that is
running. The following list shows the field size values for the
different DB2 UDB versions. Use the correct value when declaring XML
Extender stored procedures.
DB2 UDB version | Size |
---|---|
6.1 | 32 |
7.1 | 64 |