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> |