Editing an RDB to XML mapping

After you have created a mapping, you can open it in the RDB to XML mapping editor by double-clicking it in the Navigator view.

Once you have created a mapping, you can perform the following tasks with it

• Map RDB table columns and XML elements and attributes.

• Map SQL statement columns and XML elements and attributes.

• Create join conditions

• Generate, edit, and validate DAD files

• Run the DAD file with the DB2 XML Extender

Creating the mapping for an RDB_node DAD file
An RDB_node mapping document access definition (DAD) file is created with a relational database table to a DTD mapping. The DAD can be used to store and retrieve data from DB2 databases.

Creating the mapping for an SQL statement DAD file
An SQL statement mapping document access definition (DAD) file 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.

Creating join conditions
You can join tables from your database and map your database columns to elements or attributes (nodes) in the target XML file.

 

Parent topic

Mapping from relational databases to XML files

 

Related concepts

Relational database to XML mapping (visual DAD builder)

 

Related tasks

Specifying the source tables and target DTD file
Creating the mapping for an RDB_node DAD file
Creating the mapping for an SQL statement DAD file
Creating join conditions