Filter
Top Products
128 The XML Files: Development of XML/XSL Applications Using WebSphere Studio
Figure 6-13 XML Extender overview
Administrative support tables, UDTs, and UDFs
The XML Extender creates the following set of administrative support tables
(Table 6-1), UDTs (Table 6-2), UDFs (Table 6-3) and stored procedures
(Table 6-4) when a database is enabled for XML.
Table 6-1 .Administrative support tables created
The schema qualifier for all the tables, UDFs and stored procedures created is
DB2XML.
Table 6-2 UDTs created
Table Name Description
XMLUsage Stores the Document Access Definition (DAD) files
DTD_Ref Stores the DTDs used to vaildate XML documents
UDT Description
XMLVarchar Stores small XML documents with base type VARCHAR
(3000 bytes)
XML Extender Overview
XML Side Tables
XML Column XML Collection
Traditional
Relational Tables
XML_USAGE
DAD
(Data
Access
Definition)
DTD_REF
XML
Documents
Application
DB2 XML Extender
Document insert, update, delete,
search & retrieve
(UDFs and Stored Procedures)
Document compose,
decompose, update & delete
(UDFs and Stored
Procedures)
User Tables
Administrative Support Tables
User Defined Tables
DTD
(Document
Type
Definition)