COMPLETE XMLSCHEMA command

The COMPLETE XMLSCHEMA command 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

Read syntax diagramSkip visual syntax diagramCOMPLETE XMLSCHEMArelational-identifierWITHschema-properties-URIENABLE 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.