XMLCOUNT()
From Lianjapedia
Contents
Purpose
Function to return the number of records from an XML file
Syntax
XMLCOUNT(<XML filename>)
See Also
COPY, FETCH, PRINT_XML(), SELECT, SET XMLFORMAT, UPDATE, XML, XML_DECODE(), XML_ENCODE(), XML_GATHER(), XML_SCATTER(), XMLCREATEDTD(), XMLFIRST(), XMLNEXT(), XMLVALIDATE(), XQUERY(), XQUERY ATTRIBUTES(), XQUERY_CLOSE(), XQUERY_COUNT(), XQUERY_DECODE(), XQUERY_FILE(), XQUERY_FIND(), XQUERY_NODE(), XQUERY_OPEN(), XQUERY_SELECT()
Description
The XMLCOUNT() function will return the number of records from an XML file.
Parameters | Required | Default | Description |
---|---|---|---|
<XML filename> | Yes | None | The name of the XML file to validate. |
If the XML file contains no records, then a value of zero will be returned.
Example
select company, street, town, state, zip from sales save as xml sales ? xmlcount("sales.xml") 25