Difference between revisions of "XMLCOUNT()"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
| Line 11: | Line 11: | ||
The XMLCOUNT() function will return the number of records from an XML file. | The XMLCOUNT() function will return the number of records from an XML file. | ||
| − | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
| − | !width=25%|Parameters||width=10%|Required||width=10%|Default||Description | + | !width="25%"|Parameters||width="10%"|Required||width="10%"|Default||Description |
|- | |- | ||
| − | |<XML filename>||valign=top|Yes||valign=top|None||The name of the XML file to validate. | + | |<XML filename>||valign="top"|Yes||valign="top"|None||The name of the XML file to validate. |
|- | |- | ||
|} | |} | ||
Revision as of 10:36, 4 February 2013
Contents
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
