ADD XMLSCHEMA DOCUMENT (Db2 command line processor)

The ADD XMLSCHEMA DOCUMENT command adds one or more XML schema documents to an existing but incomplete XML schema.

Read syntax diagramSkip visual syntax diagram ADD XMLSCHEMA DOCUMENT TO relational-identifier ADDschemaLocation-URIFROMcontent-URIWITHproperties-URICOMPLETEWITHschema-properties-URI
TO relational-identifier
Specifies the relational name of a registered, but incomplete, XML schema to which additional schema documents are to be added.

The schema of the relational identifier must be SYSXSR. If you specify a qualified name, the qualifier must be SYSXSR, such as, SYSXSR.MYSCHEMA. If you specify an unqualified name, you need to execute the SQL statement SET SCHEMA="SYSXSR" before you execute the command. A name that is enclosed in quotation marks, such as "SYSXSR.MYSCHEMA," is considered an unqualified name. Qualifiers or schema names that are enclosed in quotation marks are not folded to uppercase. Qualifiers or schema names that are not enclosed in quotation marks are folded to uppercase.

ADD schemaLocation-URI
Specifies the schema location URI of an XML schema document that is to be added to this schema, as the document is likely to be referenced from another XML document.
FROM content-URI
Specifies the URI where the actual content of an XML schema document is located. The command line processor supports only file URIs, which begin with file://.
WITH properties-URI
Specifies that the URI of a properties document is to be associated with a schema document. The Db2 command line processor supports only file URIs, which begin with file://.
COMPLETE
Indicates that no more XML schema documents need to be associated with this XML schema, other than those that are indicated in this ADD XML SCHEMA DOCUMENT command. Validation of the schema is to be performed, and, if no errors are found, the schema is to be marked as usable. Until XML schema registration is completed, the schema is not visible to or usable in other SQL or XML commands.
WITH schema-properties-URI
Specifies the URI of a properties document to be associated with this XML schema. The Db2 command line processor supports only file URIs, which begin with file://. A schema properties document can be specified only when the XML schema is also being completed.

Examples

Example: Adding documents to an XML schema and completing schema registration
An XML schema that is referred to by the relational name JOHNDOE.PRODSCHEMA1 already is registered. Two more documents need to be added to the list of schema documents associated with the schema. The first document is http:// mycompany.com/xml/schema/order.xsd, which is stored locally in /u/temp. The second document is http:// othercompany.com/external/po.xsd, which is also stored locally in /u/temp. Neither document has an associated properties file, and you are certain that no other documents are referenced by the schema. Issue these commands to add the documents and complete registration:
ADD XMLSCHEMA DOCUMENT TO JOHNDOE.PRODSCHEMA1
ADD http://mycompany.com/xml/schema/order.xsd 
FROM file:///u/temp/order.xsd
ADD http://othercompany.com/external/po.xsd 
FROM file:///u/temp/po.xsd
COMPLETE
Example: Adding documents to an XML schema without completing schema registration
An XML schema that is referred to by the relational name JOHNDOE.TEST is registered, and you need to add a single document without completing the registration. The schema document is http://johndoe.com/test/test3.xsd and it is stored locally in /usr/jdoe/test/test3.xsd. Issue this command to add the document:
ADD XMLSCHEMA DOCUMENT TO JOHNDOE.TEST 
ADD http://johndoe.com/test/test3.xsd
FROM file:///usr/jdoe/test/test3.xsd