Sample queries

This query selects all the book titles from bookstore.xml:

java com.sybase.xml.xql.XqlDriver -qstring "/bookstore/book/title" 	
     -infile bookstore.xml

Query  returned true and the  result is

<xql_result>
<title>Seven Years in Trenton</title>
<title>History of Trenton</title>
<title>Trenton Today, Trenton Tomorrow</title>
</xql_result> 

This example lists all the author’s first names from bookstore.xml. XQL uses a zero-based numbering system; that is, “0” specifies the first occurrence of an element in a file.

java com.sybase.xml.xql.XqlDriver 	
     -qstring "/bookstore/book/author/first-name[0]" 	
     -infile bookstore.xml
Query  returned true and the  result is

<xql_result>
		<first-name>Joe</first-name>
		<first-name>Mary</first-name>
		<first-name>Toni</first-name>
</xql_result> 

The following example lists all the authors in bookstore.xml whose last name is “Bob”:

java com.sybase.xml.xql.XqlDriver 
     -qstring "/bookstore/book/author[last-name='Bob']" 	
     -infile bookstore.xmlQuery  returned true and the  result is

<xql_result>
     <author>
     <first-name>Joe</first-name>
     <last-name>Bob</last-name>
     <award>Trenton Literary Review Honorable Mention</award></author>
     <author>
     <first-name>Mary</first-name>
     <last-name>Bob</last-name>
     <publication>Selected Short Stories of
     <first-name>Mary</first-name>
     <last-name>Bob</last-name></publication></author>
     <author>
     <first-name>Toni</first-name>
     <last-name>Bob</last-name>
     <degree from=Trenton U>B.A.</degree>
     <degree from=Harvard>Ph.D.</degree>
     <award>Pulizer</award>
     <publication>Still in Trenton</publication>
     <publication>Trenton Forever</publication></author>
</xql_result>