XMLTRANSFORM()

Syntax

XMLTRANSFORM( value, transform )

Usage

Any transform returning a value of Null is eliminated from the result. If value is Null, or if the sequence produced is of zero length, then the function returns Null.

See Also

• XMLPARSE

• XMLSERIALIZE

Example

The following example shows a transform. Note: The string inside of XMLPARSE is intended to be one long string:

INSERT INTO OutStream
SELECT XMLTRANSFORM(OrderVal1
   XMLPARSE('<xsl:stylesheet version = ''1.0'' 
 xmlns:xsl=''http://www.w3.org/1999/XSL/Transform''>
      <xsl:template match="/">
      <custname><xsl:value-of select="//name"/></custname>
      <providerID><xsl:value-of select=
      "//orderid"/></providerID>
      </xsl:template>
      </xsl:stylesheet>'))
FROM Trades;