The native XML processor supports SQL extensions that perform XML query functions on XML documents. The native XML processor can query both stored XML documents and XML documents mapped from SQL by the for xml clause or forxmlj function.
Integration of the native XML processor in Adaptive Server 12.5.1 provides remarkable performance improvements over the Java-based XQL processor of earlier versions of Adaptive Server.
The native XML processor supports standard XML documents and standard XPath queries, which are a subset of the new XQuery language. XML Services in Adaptive Server describes the subsets of those standards that the native XML processor supports.
The SQL extensions supported by the native XML processor are:
xmlextract – a built-in function that applies an XML query expression to an XML document and returns the select result.
xmltest – a SQL predicate that applies an XML query expression to an XML document and returns the Boolean result.
xmlparse – a built-in function that parses an XML document for more efficient processing.
xmlrepresentation – a built-in function that determines whether a given image column contains a parsed XML document.
For more information, see XML Services in Adaptive Server Enterprise.
