IBM Books

XML Extender Administration and Programming

DAD file: XML - RDB_node mapping

This DAD file uses <RDB_node> elements to define the DB2 tables, columns, and conditions that are to contain XML data.

Figure 18. Sample DAD file for an XML collection using RDB_node mapping

<?xml version="1.0"?> 
<!DOCTYPE Order SYSTEM "c:\dxx\dtd\dad.dtd"> 
<DAD> 
   <dtdid>c:\dxx\samples\dtd\getstart.dtd</dtdid> 
   <validation>YES</validation> 
<Xcollection> 
      <prolog>?xml version="1.0"?</prolog> 
      <doctype>!DOCTYPE Order SYSTEM "c:\dxx\samples\dtd\getstart.dtd"</doctype> 
      <root_node> 
         <element_node name="Order"> 
           <RDB_node> 
              <table name="order_tab"/> 
              <table name="part_tab"/> 
              <table name="ship_tab"/> 
              <condition> 
                order_tab.order_key = part_tab.order_key AND 
                part_tab.part_key = ship_tab.part_key 
              </condition> 
           </RDB_node> 
           <attribute_node name="key"> 
              <RDB_node> 
                 <table name="order_tab"/> 
                 <column name="order_key"/> 
              </RDB_node> 
           </attribute_node> 
           <element_node name="Customer"> 
              <text_node> 
                 <RDB_node> 
                    <table name="order_tab"/> 
                    <column name="customer"/> 
                 </RDB_node> 
              </text_node> 
           </element_node> 
           <element_node name="Part"> 
              <RDB_node> 
                 <table name="part_tab"/>  
                 <table name="ship_tab"/> 
                 <condition> 
                    part_tab.part_key = ship_tab.part_key 
                 </condition> 
              </RDB_node> 
              <attribute_node name="key"> 
                 <RDB_node> 
                    <table name="part_tab"/> 
                    <column name="part_key"/> 
                 </RDB_node> 
              </attribute_node> 
           
           <element_node name="Quantity"> 
              <text_node> 
                 <RDB_node> 
                    <table name="part_tab"/> 
                    <column name="quantity"/> 
                 </RDB_node>  
              </text_node> 
           </element_node> 
           <element_node name="ExtendedPrice"> 
              <text_node> 
                 <RDB_node> 
                    <table name="part_tab"/> 
                       <column name="price"/>  
                       <condition> 
                          price > 2500.00 
                       </condition> 
                 </RDB_node> 
              </text_node>  
           </element_node> 
           <element_node name="Tax">  
              <text_node> 
                 <RDB_node> 
                    <table name="part_tab"/> 
                    <column name="tax"/>  
                 </RDB_node> 
              </text_node>  
           </element_node> 
 
 
           <element_node name="shipment">  
              <RDB_node> 
                 <table name="ship_tab"/> 
                 <condition> 
                    part_key = part_tab.part_key 
                 </condition> 
              </RDB_node> 
              <element_node name="ShipDate"> 
                 <text_node> 
                    <RDB_node> 
                       <table name="ship_tab"/> 
                       <column name="date"/>  
                       <condition> 
                          date > "1966-01-01" 
                       </condition> 
                    </RDB_node> 
                 </text_node>  
              </element_node> 
              <element_node name="ShipMode">  
                 <text_node> 
                    <RDB_node> 
                       <table name="ship_tab"/> 
                       <column name="mode"/>  
                    </RDB_node> 
                 </text_node>  
              </element_node> 
              <element_node name="Comment"> 
                 <text_node> 
                    <RDB_node> 
                       <table name="ship_tab"/> 
                       <column name="comment"/>  
                    </RDB_node> 
                 </text_node>  
              </element_node> 
            </element_node> <! -- end of element Shipment> 
          </element_node> <! -- end of element Part ---> 
        </element_node> <! -- end of element Order ---> 
      </root_node> 
  </Xcollection> 
</DAD>


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