MSCEWI3016

XML is not supported.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

The following XML related functions are not supported:

• EXTRACT

• EXTRACTVALUE

• XMLSEQUENCE

• XMLTYPE

Example Code

Input Code:

select * from table(XMLSequence(XMLType('
<Product ProductCode="200">
 <BrandName>Notebook</BrandName>
 <ProductList>
  <Item ItemNo="200A"><Price>900</Price></Item>
  <Item ItemNo="200B"><Price>700</Price></Item>
  <Item ItemNo="200C"><Price>650</Price></Item>
  <Item ItemNo="200D"><<Price>750</Price></Item>
</ProductList>
</Product>')));

Output Code:

select * from table(/*** MSC-ERROR - MSCEWI3016 - FUNCTION RELATED WITH XML NOT SUPPORTED ***/
XMLSEQUENCE_STUB('XMLSequence(/*** MSC-ERROR - MSCEWI3016 - FUNCTION RELATED WITH XML NOT SUPPORTED ***/XMLTYPE_STUB(\'XMLType(\\'<Product ProductCode="200"> <BrandName>Notebook</BrandName> <ProductList>  <Item ItemNo="200A"><Price>900</Price></Item>  <Item ItemNo="200B"><Price>700</Price></Item>  <Item ItemNo="200C"><Price>650</Price></Item>  <Item ItemNo="200D"><<Price>750</Price></Item></ProductList></Product>\\')\'))'));

Recommendations

• The XML function is converted to a user-defined function (UDF/Stub), so you can modify it to emulate the functionality.

• If you need more support, you can email us at [email protected]