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 xmlxfsTabgo filename
-------------------------------------------------
bookstore.1.xml
<title>Seven Years in Trenton</title>
bookstore.2.xml
<title>Modern Database Management</title>

(2 rows affected)



Copyright © 2003. Sybase Inc. All rights reserved. Example Importing XML documents or XML query results to an Adaptive Server table

View this book as PDF