IBM Books

XML Extender Administration and Programming


Managing XML collection data

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 size parameter, UDB_SIZE

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


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]