XMLCOUNT()

From Recital Documentation Wiki
Revision as of 14:17, 19 November 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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