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

export this attribute, give the schema relational name, which was used to
validate this XML value when it was inserted.

IMPORT syntax
We explain the new options for the IMPORT command using the following
command:
IMPORT FROM export.del OF DEL XML FROM xmlpath MODIFIED BY XMLCHAR
XMLPARSE PRESERVE WHITESPACE XMLVALIDATE USING XDS DEFAULT SCHEMA_A,
IGNORE (SCHEMA_B, SCHEMA_C, SCHEMA_D) MAP ((SCHEMA_E, SCHEMA_F),
(SCHEMA_G, SCHEMA_H)) INSERT INTO T1

The explanations for the terms in the command are:
XML FROM option
Specify one or more paths where the XML files are stored.
MODIFIED BY XMLCHAR option
Specify that the XML data in the files is in application character code page.
MODIFIED BY XMLGRAPHIC option
Specify that the XML data in the files are in application graphic code page.
XMLPARSE option
Indicate that the whitespace in the XML values would be removed or not.
STRIP WHITESPACE removes the whitespaces and the PRESERVE
WHITEPACE option preserves the whitespaces in the XML value.
XMLVALIDATE option
Specify how to validate the XML values before importing them in the table
column. There are three options to validate an XML value:
-

XMLVALIDATE USING XDS option
Specify that the XML value is validated using XDS's SCH attribute. Use
the DEFAULT clause of this option to specify the default schema name in
case XDS does not contain the SCH attribute. Use the IGNORE clause to
ignore some schemas. In case the SCH attribute value is any, the
schema mentioned in the IGNORE clause, validation is ignored and the
value is imported without any validation.
Use the MAP clause to map a schema to other schema. The MAP clause
has a set of schemas for each entry. If the SCH attribute value is any of
the schema mentioned in the first schema name in the set of schema
values in the MAP clause, the schema is mapped to the second schema
entry in the same set and the validation is done against the mapped
schema.