Databases Reference
In-Depth Information
Tip:
For a particular row, you can only apply one of the DEFAULT,
IGNORE, or MAP clauses. The priority of these clauses is DEFAULT,
IGNORE, and MAP. This means that if the XDS does not contain the
SCH attribute, the schema in the DEFAULT clause is used and cannot
be further mapped or ignored. Similarly, a schema, which is already
mapped, cannot be ignored. It might be possible that the SCH attribute
for rows has the same value as the DEFAULT clause. In that case, the
schema can be ignored or mapped because the DEFAULT clause is
not applicable to that.
-
XMLVALIDATE USING SCHEMA option
Specify that the XML value should be validated against the schema
specified here. The SCH attribute is ignored in every case.
-
XMLVALIDATE USING SCHEMALOCATION HINTS option
Specify that XML values are validated using the schemalocation hints
present in the XML value itself. The SCH attribute is ignored.
EXPORT syntax
We explain the new option for the
EXPORT
command using the following
command:
EXPORT TO
export.del
OF DEL XML
TO
/xmlpath
XMLFILE
xmldocs
MODIFIED BY
XMLINSEPFILES XMLCHAR XMLSAVESCHEMA
SELECT * FROM T1
The explanations of the terms in the command are:
XML TO clause
This clause provides the paths where the XML data is stored. The default
value for this clause is the path where the data file is written. Multiple values
can be given for this clause. If the multiple values are provided, export will
cycle between the paths to write each column value to the appropriate XML
file.
XMLFILE option
This option supplies the base name of the XML file where the XML values are
written.The default value for the base name is the name of the data file. The
full name of the file consists of the base name followed by a number, which is
padded to three digits and then the three letter identifier (XML). For the
previous command, the file name is xmldocs.001.xml.
Search WWH ::
Custom Search