Difference between revisions of "XMLCOUNT()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return the number of records from an XML file | Function to return the number of records from an XML file | ||
| − | |||
==Syntax== | ==Syntax== | ||
XMLCOUNT(<XML filename>) | XMLCOUNT(<XML filename>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[COPY]], [[FETCH]], [[SQL SELECT|SELECT]], [[SET XMLFORMAT]], [[SQL UPDATE|UPDATE]], [[XML]], [[XML_DECODE()]], [[XML_ENCODE()]], [[XML_GATHER()]], [[XML_SCATTER()]], [[XMLCREATEDTD()]], [[XMLFIRST()]], [[XMLNEXT()]], [[XMLVALIDATE()]] | + | [[COPY]], [[FETCH]], [[PRINT_XML()]], [[SQL SELECT|SELECT]], [[SET XMLFORMAT]], [[SQL UPDATE|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== | ==Description== | ||
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="25%"|Parameters||width="10%"|Required||width="10%"|Default||Description |
| − | !Parameters||Required||Default||Description | + | |
|- | |- | ||
| − | |<XML filename>||Yes||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. |
|- | |- | ||
|} | |} | ||
| − | |||
If the XML file contains no records, then a value of zero will be returned. | If the XML file contains no records, then a value of zero will be returned. | ||
| − | |||
==Example== | ==Example== | ||
| Line 33: | Line 27: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:XML]] | [[Category:XML]] | ||
| − | |||
Latest revision as of 08:37, 29 February 2016
Contents
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
