DB2 Version 9.7 for Linux, UNIX, and Windows

ADD XMLSCHEMA DOCUMENT command

Adds one or more XML schema documents to an existing but incomplete XML schema before completing registration.

Authorization

The following authority is required:

The user ID must be the owner of the XSR object as recorded in the catalog view SYSCAT.XSROBJECTS.

Required connection

Database

Command syntax


>>-ADD XMLSCHEMA DOCUMENT--TO--relational-identifier------------>

   .----------------------------------------------------------------.   
   V                                                                |   
>----ADD--document-URI--FROM--content-URI--+----------------------+-+-->
                                           '-WITH--properties-URI-'     

>--+--------------------------------------------------------------------+-><
   '-COMPLETE--+----------------------------+--+----------------------+-'   
               '-WITH schema-properties-URI-'  '-ENABLE DECOMPOSITION-'

Description

TO relational-identifier: Specifies the relational name of a registered but incomplete XML schema to which additional schema documents are added.
ADD document-URI: Specifies the uniform resource identifier (URI) of an XML schema document to be added to this schema, as the document would be referenced from another XML document.
FROM content-URI: Specifies the URI where the XML schema document is located. Only a file scheme URI is supported.
WITH properties-URI: Specifies the URI of a properties document for the XML schema. Only a file scheme URI is supported.
COMPLETE: Indicates that there are no more XML schema documents to be added. If specified, the schema is validated and marked as usable if no errors are found.
WITH schema-properties-URI: Specifies the URI of a properties document for the XML schema. Only a file scheme URI is supported.
ENABLE DECOMPOSITION: Specifies that this schema is to be used for decomposing XML documents.

Example

ADD XMLSCHEMA DOCUMENT TO JOHNDOE.PRODSCHEMA
   ADD 'http://myPOschema/address.xsd'
   FROM 'file:///c:/TEMP/address.xsd'