XMLCOUNT()

Purpose

Function to return the number of records from an XML file

Syntax

XMLCOUNT(<XML filename>)

See Also

COPY, FETCH, SELECT, SET XMLFORMAT, UPDATE, XML, XML_DECODE(), XML_ENCODE(), XML_GATHER(), XML_SCATTER(), XMLCREATEDTD(), XMLFIRST(), XMLNEXT(), XMLVALIDATE()

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

Products

Recital, Recital Server