Difference between revisions of "XQUERY OPEN()"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== Used to open XML files for parsing using Xquery notation ==Syntax== XQUERY_OPEN(<expC1>) ==See Also== MQCLOSE(), MQCREATE(), MQCURMSGS(), [[MQOPEN()]...") |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
| − | Used to open XML files for parsing using | + | Used to open XML files for parsing using XQuery notation |
==Syntax== | ==Syntax== | ||
| Line 9: | Line 9: | ||
==Description== | ==Description== | ||
| − | The XQUERY_OPEN() function is used to open an XML file for parsing using | + | The XQUERY_OPEN() function is used to open an XML file for parsing using XQuery notation. The character expression <expC1> is the XML file. After opening using XQUERY_OPEN(), the XQUERY_FIND() function can be used to search for a specified XML tag and XQUERY_COUNT() to return a count of a specified XML tag. The XQUERY_CLOSE() function is used to close the XML file. |
==Example== | ==Example== | ||
Revision as of 08:56, 16 February 2016
Contents
Purpose
Used to open XML files for parsing using XQuery notation
Syntax
XQUERY_OPEN(<expC1>)
See Also
MQCLOSE(), MQCREATE(), MQCURMSGS(), MQOPEN(), MQSEND(), MQRECEIVE(), MQUNLINK(), XML_DECODE(), XML_ENCODE(), XML_GATHER(), XML_SCATTER(), XQUERY(), XQUERY_CLOSE(), XQUERY_COUNT(), XQUERY_DECODE(), XQUERY_FILE(), XQUERY_FIND()
Description
The XQUERY_OPEN() function is used to open an XML file for parsing using XQuery notation. The character expression <expC1> is the XML file. After opening using XQUERY_OPEN(), the XQUERY_FIND() function can be used to search for a specified XML tag and XQUERY_COUNT() to return a count of a specified XML tag. The XQUERY_CLOSE() function is used to close the XML file.
Example
mybooks.xml
<?xml version="1.0" encoding="UTF-8"?> <bookstore> <book category="COOKING"> <title lang="en">Pulse</title> <author>Jenny Chandler</author> <year>2013</year> <format>Hardback</format> </book> <book category="COOKING"> <title lang="en">Riverford Farm Cook Book</title> <author>Guy Watson</author> <author>Jane Baxter</author> <year>2008</year> <format>Paperback</format> </book> <book category="CHILDREN"> <title lang="en">The House At Pooh Corner</title> <author>A. A. Milne</author> <year>1928</year> <format>Hardback</format> </book> <book category="CRIME"> <title lang="en">Knots and Crosses</title> <author>Ian Rankin</author> <year>2008</year> <format>EPUB</format> </book> <book category="PHILOSOPHY"> <title lang="fr">Le mythe de Sisyphe</title> <author>Albert Camus</author> <year>1943</year> <format>Paperback</format> </book> </bookstore>
// Examples using mybooks.xml xquery_open("mybooks.xml") nCount = xquery_count("/bookstore/book") for i=1 to nCount cTitle = xquery_find("/bookstore/book[&i]/title") ? cTitle endfor xquery_close() Pulse Riverford Farm Cook Book The House At Pooh Corner Knots and Crosses Le mythe de Sisyphe xquery_open("mybooks.xml") nCount = xquery_count("/bookstore/book") for i=1 to nCount nCountAuthor = xquery_count("/bookstore/book[&i]/author") for j = 1 to nCountAuthor cAuthor = xquery_find("/bookstore/book[&i]/author[&j]") ? cAuthor endfor endfor xquery_close() Jenny Chandler Guy Watson Jane Baxter A. A. Milne Ian Rankin Albert Camus
