To define the association between elements and attributes in an XML schema and columns in DB2^® relational database tables, you must select the target database tables. The tables can be located in one or more database schemas in your DB2 data connection.

You can either drag tables from your data connection in the Server Explorer, or you can select them from a list.

Requirement:  An instance of the IBM XML Schema Mapping Designer must be open, with an XML schema displayed in the Source XML schema pane.

To add target tables for XML mapping:

• Drag the tables from the Server Explorer.
  1. In the Server Explorer under your data connection, expand the Tables node.
  2. Drag each table that contains columns for which you want to define associations to the right pane in the Mapping Editor section of the Annotated XML Schema view.
• Select the tables from a list.
  1. Right-click in the Mapping Editor section of the Annotated XML Schema view, and then select Add Target Table on the shortcut menu.

     The Add Table window opens.

  2. Select one or more tables in the list.

     Use the Ctrl or Shift key to select multiple tables.

  3. Click OK.

A graphic of each table that you dragged or selected is displayed in the right pane of the editor. You can arrange the table graphics so that they are easy to map to.

See Also

Annotating XML Schemas | IBM XML Schema Mapping Designer

.NET Development Forum   DB2 FAQs

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