IBM Books

XML Extender Administration and Programming


XML usage table

Stores common information for each XML-enabled column. The XML_USAGE table's schema name is db2xml, and its primary key is (table_name, col_name). An XML_USAGE table is created at the time the database in enabled with the columns listed in Table 51.

Table 51. XML_USAGE table
Column name Data type Description
table_schema CHAR(UDB_SIZE+1) For XML column, the schema name of the user table that contains an XML column. For XML collection, a value of "DXX_COLL" as the default schema name.
table_name CHAR( UDB_SIZE+1) For XML column, the name of the user table that contains an XML column. For XML collection, a value "DXX_COLLECTION," which identifies the entity as a collection.
col_name CHAR( UDB_SIZE+1) The name of the XML column or XML collection. It is part of the composite key along with the table_name.
DTDID CHAR( UDB_SIZE+1) The ID of the DTD in the DTD_REF table to define the DAD file. It is the foreign key.
DAD CLOB(100k) The content of the DAD file that is associated with the column.
default_view CHAR( UDB_SIZE+1) Stores the default view name if there is one.
trigger_suffix CHAR(8) Not NULL. For unique trigger names.
Validation INTEGER 1 for yes, 0 for no.

Restriction: The DTD can be modified by the application only when the USAGE_COUNT is zero.


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