XMLCOUNT()

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