XML Values

An XML value is a value composed of XML elements and attributes, where elements can contain other XML elements or text. XML values can be created directly or built by parsing string values. XML values cannot be stored in records, but can be converted to string representation and stored in that form.

Operations on XML Values

You can declare a variable of xml type and assign it to XML values:

xml xmlVar;

In addition to declaring a variable for use with XML values, you can also perform the following operations:

xmlagg – Aggregate a number of XML values into a single value. This can be used only in aggregate streams or with event caches (see below).
Syntax: xmlagg(xml value)

Type: The argument must be an XML value. The function returns an XML value.

Example: xmlagg(xmlparse(stringCol))
xmlconcat – Concatenate a number of XML values into a single value.
Syntax: xmlconcat(xml value ..., xml value)

Type: The arguments must be XML values. The function returns an XML value.

Example: xmlconcat(xmlparse(stringCol), xmlparse('<t/>'))
xmlelement – Create a new XML data element, with attributes and XML expressions within it.
Syntax: xmlelement(name xmlattributes(string AS name ..., string AS name) , xml value,...,xml value)

Type: The names must adhere to these conventions:
- A name is either a sequence of alphabetic characters, digits, and underscore characters, or a sequence of any characters enclosed in double quotation marks.
- If a name is not enclosed in double quotation marks, it must begin with an alphabetic character or an underscore.
- A name cannot contain spaces unless it is enclosed in double quotation marks.
- A name cannot be a Reserved Word unless it is enclosed in double quotation marks. Reserved words are case insensitive, so for example, a name cannot be “AND” or “and” or “AnD”.
- Columns cannot be named “rowid” or “rowtime”.
The function returns an XML value.

Example: xmlelement(top, xmlattributes('data' as attr1), xmlparse('<t/>'))
xmlparse – Convert a string to an XML value.
Syntax: xmlparse(string value)

Type: The argument must be a string value. The function returns an XML value.

Example: xmlparse('<tag/>')
xmlserialize – Convert an XML value to a string.
Syntax: xmlserialize(xml value)

Type: The argument must be an XML value. The function returns a string.

Example: xmlserialize(xmlparse('<t/>'))