Generating a DAD File for IBM DB2

IBM DB2 v8.1 (or higher) is a database server with an add-in for XML storage and retrieval called IBM DB2 Extender. XML data (elements, attributes) are mapped to relational data (tables, columns) through Document Access Definition files (.DAD).

There are three types of DAD files:

Storage Type	Description
Xcolumn	Column mapping - the Root element is mapped to a table, and its attributes or child elements are mapped to columns identified by an XPath
Xcollection	SQL mapping - the DAD file starts with a SQL statement for the table mapped to the Root element, and each child element or attribute is mapped to a column or a table name
Xcollection	RDB mapping - a Relational Database node, with a table and a column name, is associated with each attribute or child element of the Root element

An XML model targeted with DTD allows you to generate DAD files for IBM DB2.

Map an XSM to a PDM. You can do this manually or by generating an XSM from a PDM (or a PDM from an XSM) but we recommend that you use the XML Builder Wizard (see Mapping database objects to an XML schema via the XML Builder Wizard)
[if you do not use the wizard] Attach the SQL/XML extended model definition (see Attaching the SQL/XML extended model definition).
Further specify the mappings with extended attributes (see Reinforcing DB2 mappings with extended attributes).
Generate the annotated schema (see Generating a DB2 DAD file).

Mapping DB2 Objects to an XML Schema Via the XML Builder Wizard
You can generate an annotated schema via the XML Builder.
Reinforcing DB2 Mappings with Extended Attributes
The IBM DB2 DAD extended model definition allows you to modify or reinforce the mapping resulting from the XML Builder Wizard via extended attributes.
Generating a DB2 DAD File
You generate the DAD file by selecting it as an additional target for standard schema generation.

Parent topic: Working with XML and Databases