These examples use two XML documents stored in the files named bookstore.1.xml and bookstore.2.xml, that you create:
cat bookstore.1.xml <?xml version='1.0' standalone = 'no'?> <!-- bookstore.1.xml example document--!> <bookstore specialty='novel'> <book style='autobiography'> <title>Seven Years in Trenton</title> <author> <first-name>Joe</first-name> <last-name>Bob</last-name> <award>Trenton Literary Review Honorable Mention</award> </author> <price>12</price> </book> </bookstore> cat bookstore.2.xml <?xml version='1.0' standalone = 'no'?> <!-- bookstore.2.xml example document--!> <bookstore specialty='novel'> <book style='compbook'> <title>Modern Database Management</title> <author> <first-name>Jeffrey</first-name> <last-name>Hoffer</last-name> </author> <price>112.00</price> </book> </bookstore>
You can reference these XML documents with File System Access, using create proxy table.
The following code sample shows the use of create proxy table. The directory pathname in the at clause must reference a file system directory that Adaptive Server can both see and search. If you add an ’;R’ (indicating "Recursion") extension to the end of the pathname CIS extracts file information from every directory subordinate to the pathname.
create proxy_table xmlxfsTab external directory at "/remote/nets3/bharat/xmldocs;R" select filename from xmlxfsTab f
filename ------------------------------------------- bookstore.1.xml bookstore.2.xml (2 rows affected)
The significant columns are filename and content. The other columns contain data for access permission and so forth. The filename column holds the file name (in this example the XML document file name) and the content column holds the actual data for that file. The datatype of the content column is image.
