DECOMPOSE XML DOCUMENT command

Authorization

One of the following groups of privileges or authorities is required:

• One of the following authorizations:
  • CONTROL privilege on all target tables referenced in the set of annotated schema documents.
  • DATAACCESS authority on the schema of all target tables referenced in the set of annotated schema documents.
  • DATAACCESS authority.
• All of the following privileges:
  • One of the following privileges:
    • DATAACESS authority on the schema or INSERTIN privilege on the schema of the target table, as required for the operation specified in the action file.
    • INSERT privilege on the target table, as required for the operation specified in the action file.
  • and one of the following privileges:
    • SELECTIN, INSERTIN, UPDATEIN, or DELETEIN privilege, or DATAACESS authority, as applicable, on the schema of any table referenced by the db2-xdb:expression or db2-xdb:condition annotation
    • SELECT, INSERT, UPDATE, or DELETE privilege, as applicable, on any table referenced by the db2-xdb:expression or db2-xdb:condition annotation
    Note: If the VALIDATE option is specified, one of the following privileges is required:

    • USAGE on the XML schema
    • DATAACCESS on the database
    • DATAACCESS on the schema

Required connection

Database

Command syntax

Command parameters

DECOMPOSE XML DOCUMENT xml-document-name

xml-document-name is the file path and file name of the input XML document to be decomposed.

XMLSCHEMA xml-schema-name

xml-schema-name is the name of an existing XML schema registered with the XML schema repository to be used for document decomposition. xml-schema-name is a qualified SQL identifier consisting of an optional SQL schema name followed by a period and the XML schema name. If the SQL schema name is not specified, it is assumed to be the value of the Db2® special register CURRENT SCHEMA.

VALIDATE

This parameter indicates that the input XML document is to be validated first, then decomposed only if the document is valid. If VALIDATE is not specified, the input XML document will not be validated before decomposition.