IBM Books

XML Extender Administration and Programming

DAD file: XML column

This DAD file contains the mapping for an XML column, defining the table, side tables, and columns that are to contain the XML data.

Figure 16. Sample DAD file for an XML column

<?xml version="1.0"?> 
<!DOCTYPE Order SYSTEM "c:\dxx\dad.dtd"> 
<DAD> 
   <dtdid>c:\dxx\samples\dtd\getstart.dtd</dtdid> 
   <validation>YES</validation> 
 
   <Xcolumn> 
     <table name="order_side_tab"> 
         <column name="order_key" 
            type="integer" 
            path="/Order/@key" 
            multi_occurrence="NO"/> 
         <column name="customer" 
            type="varchar(50)" 
            path="/Order/Customer/Name" 
            multi_occurrence="NO"/> 
     </table> 
     <table name="part_side_tab">
         <column name="price" 
            type="decimal(10,2)" 
            path="/Order/Part/ExtendedPrice" 
            multi_occurrence="YES"/>
     </table>
     <table name="ship_side_tab">
         <column name="date" 
            type="DATE" 
            path="/Order/Part/Shipment/ShipDate" 
            multi_occurrence="YES"/>
     </table> 
 
   </Xcolumn> 
 
</DAD>


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]