Relational database to XML mapping (visual DAD builder)

The relational database (RDB) to XML mapping editor is a visual tool used for mapping relational tables or an SQL statement to a DTD. After completing the mapping, you can generate a document access definition (DAD) file that can be run by the DB2 XML Extender to compose or decompose other XML documents into DB2 data.

There are 2 kinds of XML Collection DAD methods supported by the relational database to XML mapping editor, RDB_node and SQL statement

• An RDB_node mapping DAD is created with a relational database table to a DTD mapping. The DAD can be used to store and retrieve data from DB2 databases.

• An SQL statement mapping DAD is created with an SQL statement (SELECT or FULLSELECT) to a DTD mapping. The DAD can be used to compose an XML document from an SQL query.

The mapping is stored in a session file with the extension .rmx .

The RDB to XML mapping editor supports the IBM DB2 Universal Database. To deploy the generated DAD script, have IBM DB2, Version 8.1 or higher.

 

DB2 XML Extender

To deploy the generated DAD script, have the DB2 XML Extender installed on your system. The DB2 XML Extender provides new data types that let you store XML documents in DB2 databases and new functions that assist you in working with these structured documents. Entire XML documents can be stored in DB2 databases as character data, or stored as external files but still managed by DB2. Retrieval functions allow you to retrieve either the entire XML document or individual elements or attributes.

. IBM DB2, Version 8.1 or higher includes it, so you do not have to install it separately.

 

Parent topic

Mapping from relational databases to XML files

Related tasks
Specifying the source tables and target DTD file
Editing an RDB to XML mapping
Creating the mapping for an RDB_node DAD file
Creating the mapping for an SQL statement DAD file
Creating join conditions