IBM Books

XML Extender Administration and Programming

From the DB2 command shell

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 ]