You define the association between elements and attributes in an XML schema and columns in DB2^® relational database tables by creating map links in the IBM XML Schema Mapping Designer. Each map link can have only one XML source node (element or attribute) and one target column. However, you can create multiple map links from the same XML source node to different target columns.

You can add map links by dragging from the XML source node to the target column or by using a command on the shortcut menu in the Mapping Editor section of the designer.

Requirement:  An instance of the IBM XML Schema Mapping Designer must be open, with an XML schema displayed in the Source XML schema pane, and one or more tables displayed in the right pane.

To add a map link:

• Drag from the element or attribute in the Source XML schema pane to the target column in the right pane.
• In the Source XML schema pane of the Mapping Editor section, right-click the XML element or attribute, select Add Map Link on the shortcut menu, and then click the target column in the right pane.

A blue line is drawn between the XML source node and the target column.

See Also

Annotating XML Schemas | Finding Nodes, Elements, and Attributes in Source XML Schemas | IBM XML Schema Mapping Designer | Keyboard Shortcuts

.NET Development Forum   DB2 FAQs

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