Use the Find Same Name window to find the relationships between
elements and attributes in the source XML schema document and columns in DB2®
relational target tables. After the relationships are discovered, you can
select the specific relationships for which you want to define map links.
To open the Find Same Name window:
In the Annotated XML Schema view of the IBM XML Schema Mapping
Designer, right-click in the Mapping Editor section,
and then select Find Same Name on the shortcut menu.
Source
Shows the nodes, elements, and attributes in the source XML schema.
Clear the check boxes of the nodes, elements, and attributes for
which you do not want to find relationships. If you clear the
check box of a node, the check boxes of all of its children are
automatically cleared. You can then select the check boxes of
individual child nodes, elements, and attributes.
Target
Shows the relational tables and columns in the schemas that are
in the current data connection. Clear the check boxes of the
schemas, tables, and columns for which you do not want to find
relationships.
If you clear the check box of a schema or table, the check boxes
of all of its tables or columns, respectively, are automatically
cleared. You can then select the check boxes of individual tables
in the schema or columns in the table.
Discover
Finds the selected columns in the relational tables whose names
match the names of the selected elements or attributes in the
source XML schema.
Discovery result
Shows the columns in the relational tables that have the same name
as elements or attributes in the source XML schema. The results
are ordered by schema, and within each schema, by table, and within
each table, by column.
A column name is followed by the path in the XML schema to its
matching element or attribute. The data type of the matching
element or attribute is shown in parentheses.
You can accept or reject any or all of the discovered
matches.
Reject
Removes the matches that you have selected in the
Discovery Result list.
You can use the Shift and Ctrl keys to select multiple matches.
Reject All
Removes all of the matches that are shown in the Discovery
Result list.
Accept
Creates map links for the matches that you have selected in the
Discovery Result list, and then removes the selected
matches from the list.
You can use the Shift and Ctrl keys to select multiple matches.
Accept All
Creates map links for all of the matches that are shown in the
Discovery Result list, and then removes the matches
from the list.