Start of change

COMPLETE XMLSCHEMA (Db2 command line processor)

The COMPLETE XMLSCHEMA command completes the registration of an XML schema.

Read syntax diagramSkip visual syntax diagram COMPLETE XMLSCHEMA relational-identifier WITHschema-properties-URI
relational-identifier
Specifies the relational name that was assigned to an XML schema in a previous REGISTER XMLSCHEMA command.

The schema of the relational identifier must be SYSXSR. If you specify a qualified name, the qualifier must be SYSXSR; for example, 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.

WITH schema-properties-URI
Specifies the URI of a properties document that is to be associated with this XML schema. The Db2 command line processor supports only file URIs, which begin with file://.
Example: Adding documents to an XML schema and completing schema registration
Suppose that a schema with relational name PRODSCHEMA is already registered. The schema has additional properties that are stored locally in file /u/temp/CUSTPROP.xml. Issue this command to complete registration:
COMPLETE XMLSCHEMA PRODSCHEMA WITH 'file:///u/temp/CUSTPROP.xml'
End of change