Chapter 3: New Features in Adaptive Server 12.5.2 and 12.5.3

XML language changes

This section describes the XML language changes in Adaptive Server release 12.5.2.

New XML query language

Table 3-5 summarizes the new commands for the XML query language.

**Table 3-5: New commands**
Function	Description
toupper	Returns the argument values in uppercase.
tolower	Returns the argument values in lowercase.
normalize-space	Makes two changes when it returns its argument value: Removes leading and trailing white-space characters. Replaces all substrings of two or more white-space characters that are not leading characters with a single white-space character.
concat	Returns the string concatenation of the argument values. It has zero or more parameters.

Table 3-6 summarizes the changes to the XML query language.

**Table 3-6: Changes to commands**
Function	Description
xmlextract	The returns clause of xmlextract now supports java.lang.String.
xmlparse	xmlparse now includes an optional returns clause that lets you specify the datatype of the returned parsed XML document.
xmlrepresentation	In addition to the image datatype, xmlrepresentation now supports binary and varbinary datatypes for the XML document operand.

Table 3-7 summarizes the new XML functions.

**Table 3-7: New Transact-SQL functions**
Function	Description
ForXmlTree	Maps a set of SQL tables or result sets to a tree-structured XML document.
OpenXml	Extracts repeating data from a tree-structured XML document to a SQL table.
forxmlmultiplej	Maps result sets of a SQL query, that can contain multiple result sets, to an XML document.