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.
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.
|