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, 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 Database Server, Recital Mirage Server, Recital Terminal Developer