
Chapter 5 Exchanging data with databases supporting XML
Generating a DAD file for IBM DB2
IBM DB2 v8.1 (or higher) is a database server with an
There are three types of DAD files:
Type of storage | Type of mapping | Description |
Xcolumn | column | The Root element is mapped to a |
|
| table, and its attributes or child |
|
| elements are mapped to columns |
|
| identified by an XPath |
Xcollection | SQL | 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 | 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. You need first to map an XML model to a PDM, then to attach the IBM DB2 DAD extended model definition to the mapped XML model, and finally (optional) to define extended attributes for global elements. Extended attributes specify the type of DAD file generated for each global element. The DAD file is generated with the DTD file and a SQL file for stored procedures.
Caution
The following procedure assumes you have a PDM open in the workspace and targeted with IBM DB2 UDB 8.x Common Server as DBMS.
If the PDM is not targeted with the proper DBMS, select Database→Change Current DBMS.
To generate a DAD file for IBM DB2:
1 In the PDM menu bar, select Tools→XML Builder Wizard.
XSM User's Guide | 237 |