Setting up your XML documents and creating the proxy table  Example: importing XML documents or XML query results to an Adaptive Server table

Appendix C: XML Services and External File System Access

Example: extracting the book title from the XML documents 

select filename , xmlextract("//book/title" , content)
from xmlxfsTab

filename
-------------------------------------------------
bookstore.1.xml
<title>Seven Years in Trenton</title>
bookstore.2.xml
<title>Modern Database Management</title>

(2 rows affected)



Copyright © 2005. Sybase Inc. All rights reserved. Example: importing XML documents or XML query results to an Adaptive Server table

View this book as PDF