COMPLETE XMLSCHEMA command

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.