XML Extender Administration and Programming
Issue an SQL INSERT statement for the DTD_REF table using the schema in
Table 7:
Table 7. The schema for the DTD_REF DTD table
Column name
| Data type
| Description
|
DTDID
| VARCHAR(128)
| Primary key (unique and not NULL). The primary key is used to
identify the DTD and must be the same as the SYSTEM ID on the DOCTYPE line in
each XML document, when validation is used. When the primary key is
specified in the DAD file, the DAD file must follow the schema that is defined
by the DTD.
|
CONTENT
| XMLCLOB
| The content of the DTD.
|
USAGE_COUNT
| INTEGER
| The number of XML columns and XML collections in the database that use
this DTD to define a DAD.
|
AUTHOR
| VARCHAR(128)
| Author of the DTD, optional information for user to input.
|
CREATOR
| VARCHAR(128)
| The user ID that does the first insertion.
|
UPDATOR
| VARCHAR(128)
| The user ID that does the last update.
|
For example:
DB2 INSERT into db2xml.dtd_ref values('c:\dxx\samples\dtd\getstart.dtd',
db2xml.XMLClobFromFile('c:\dxx\samples\dtd\getstart.dtd'), 0, 'user1',
'user1', 'user1')
Important for XML collections: The DTD ID is a path
specifying the location of the DTD on the local system. The DTD ID must
match the value that is specified in the DAD file for the <DTDID>
element.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]