Application development with DB2 pureXML - DB2 Express-C: The Developer for XML, PHP, C/C++, Java, and .NET - page 65

- schemalocation: Namespace of the primary XML schema. This parameter
is of the type VARCHAR(1000).
- content: Content of the XML schema document. This parameter is of the
type BLOB(30M). This is a non-nullable parameter.
- docproperty: Content of the property document associated with the
schema. This parameter is of the type BLOB(5M).
SYSPROC.XSR_ADDSCHEMADOC
Use this stored procedure to add the XML Schema documents to the primary
schema:
XSR_ADDSCHEMADOC (rschema, name, schemalocation, content,
docproperty)
The explanations for the terms in the command are:
- rschema: Relational schema for XML schema
- name: Relational Schema name for primary XML schema
- schemalocation: Namespace for the XML Document
- content: Content of the XML document as a BLOB variable
- docproperty: Property document associated with the XML schema
document
SYSPROC.XSR_COMPLETE
Use this procedure to complete the registration:
XSR_COMPLETE(rschema, name, schemaproperty, isusedforshred)
The terms in the command are explained as follows:
- rschema: Relational schema for the XML schema.

- name: Relational identifier of the primary XML schema.

- schemaproperty: An input argument of type BLOB (5M) that specifies

properties, if any, associated with the XML schema. The value for this
argument is either NULL, if there are no associated properties, or an XML
document representing the properties for the XML schema.

- isusedforshred: The value for this parameter is true if the schema is used

for decomposition, otherwise, the value is false.

2.2.7 Annotated XML schema decomposition

XML decomposition or shredding is the process of breaking down an XML
document into columns of relational tables. Consider that your organization can
have an existing relational database repository and business applications built on