The idsxmlparse() XML function

Parse an XML document or fragment to determine whether it is well formed.

Purpose

This function returns an XML document or fragment if the input XML is well formed.

The idsxmlparse() syntax


1  idsxmlparse ( xml_document )

Parameters

xml_document
The XML document or fragment to parse to determine whether it is well formed.

Example 1

SELECT idsxmlparse(
'<purchaseOrder poNo="124356">
<customerName>ABC Enterprises</customerName>
<itemNo>F123456</itemNo>
</purchaseOrder>') 
AS PO FROM systables where tabid = 1;

<purchaseOrder poNo="124356">
<customerName>ABC Enterprises</customerName>
<itemNo>F123456</itemNo>
</purchaseOrder>