The IBM^® Database Add-Ins for Visual Studio provide the functionality for you to decompose data from XML documents and store the data into columns in DB2^® database tables. The documents that specify how to decompose XML data are the annotated XML schemas.

An annotated XML schema contains the information that defines the associations between elements and attributes in the XML schema and the columns in the DB2 database tables to which they are mapped. You annotate XML schemas in the Annotated XML Schema view of the IBM XML Schema Mapping Designer.

To annotate an XML schema:

1. In the Server Explorer, right-click XML Schema Repository under your data connection, and then select Add Annotated XML Schema on the shortcut menu.

   The IBM XML Schema Mapping Designer opens.

2. Select the XML schema to annotate.
3. Optional: Find the relationships between elements and attributes in the source XML schema and columns in relational tables.

   You can also perform this step after any of steps 4-10.

4. Add one or more target tables to the Mapping Editor section.
5. Add one or more map links.
6. Optional: Specify values for the properties of the map links.
7. Optional: Hide a target table or map link.
8. Optional: Show all hidden target tables and map links.
9. Optional: Remove a target table or map link.
10. Optional: Review the annotated XML source of the map links that you have added and property values that you have specified.
11. Save the annotated XML schema.

    Saving an annotated XML schema also registers it in the XML Schema Repository.

12. Optional: Test the associations that you have defined in the annotated XML schema.

See Also

Annotated XML Schemas

.NET Development Forum   DB2 FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.