In places where a data type is called for, the XML type is specified as follows:
XML |
XML documents are processed in a parsed format using the XML conversion command (phdxmlcnv) or an XML conversion library. This format is known as ESIS-B format.
An XML type value in ESIS-B format cannot exceed 2,147,483,647 bytes. In ESIS-B format, the length depends not only on the length of the XML document, but also on its structure, such as the number of XML elements.
XML type values can be generated using the XML constructor function or the XMLPARSE function.
For details about the XML constructor function, see 1.14.2 XML constructor function. For details about the XMLPARSE function, see 1.14.3(3) XMLPARSE.
XML type values cannot be retrieved directly by a UAP. XML type values can be retrieved as VARCHAR or BINARY type values using the following method.
The following can be specified as XML type value expressions:
XML type values can be assigned only to columns, SQL variables, and SQL parameters defined as the XML type. Values of other data types cannot be assigned to the XML type. Furthermore, comparisons between other data types and the XML type are not permitted.
If no value is generated by the XML constructor function, or if a null value is specified as an argument to the XML constructor function, its XML type value is the null value. If the null value is specified as an argument to the XMLPARSE function, the XML type value is also the null value.