Completes the process of registering an XML schema in the
XML schema repository (XSR).
Authorization
- The user ID must be the owner of the XSR object as recorded in
the catalog view SYSCAT.XSROBJECTS.
Required connection
Database
Command syntax
>>-COMPLETE XMLSCHEMA--relational-identifier-------------------->
>--+-----------------------------+--+----------------------+---><
'-WITH--schema-properties-URI-' '-ENABLE DECOMPOSITION-'
Description
- relational-identifier
- Specifies the relational name of an XML schema previously registered
with the REGISTER XMLSCHEMA command. The relational
name can be specified as a two-part SQL identifier, consisting of
the SQL schema and the XML schema name, having the following format: SQLschema.name. The default SQL schema, as defined in the
CURRENT SCHEMA special register, is used if no schema is specified.
- WITH schema-properties-URI
- Specifies the uniform resource identifier (URI) of a properties
document for the XML schema. Only a local file, specified by a file
scheme URI, is supported. A schema property document can only be
specified during the completion stage of XML schema registration.
- ENABLE DECOMPOSITION
- Indicates that the schema can be used for decomposing XML instance
documents.
Example
COMPLETE XMLSCHEMA user1.POschema WITH 'file:///c:/TEMP/schemaProp.xml'
Usage notes
An XML schema cannot be referenced
or used for validation or annotation until the XML schema registration
process has been completed. This command completes the XML schema
registration process for an XML schema that was begun with the REGISTER XMLSCHEMA command.