In the XML Indexes view of the IBM® Table Designer,
you define the indexes on the XML columns of the DB2® table.
This view is available only when the data server on the connection
supports the XML data type.
Indexes
Shows the indexes for the XML columns of the DB2 table.
Name
Shows the automatically generated name of the XML index.
You can change the name to a more descriptive term.
XML Pattern
Shows the XML pattern that is defined for the index.
You cannot specify the pattern in this field.
Either type the XML pattern in the XMLPattern
property, or build it in the XML Pattern Source
section.
Index Properties
Set the property values for the index that is selected
in the Indexes list. You must specify values for
the following properties:
Column
The name of the XML column for which you are
defining an index. You can define more than one
index for the same XML column.
DataType
Select the data type.
Specify values for the other properties, as appropriate.
An unavailable property is a limitation of the database
that you are using.
Select a property to see its description in the box under
the properties list. If the description exceeds the size
of the box, hover the mouse pointer over the last line of
text in the box. After a brief pause, the full description
is shown in a ScreenTip.
XML Pattern Source
If you did not specify a value for the XMLPattern property,
in this section you build the XML pattern for the XML index.
The XML pattern is an XPath expression that defines the location
path for the node-set that you want to include in the index.
Select
Click this button to select an XML schema or XML document
as the source for the XML pattern.
XML Tree
This page shows the hierarchical structure of the nodes in
the XML schema or XML document that you selected.
Click the element node or text node that you want to select
for the XML pattern.
To select all the element nodes that are the same as the
selected node, right-click the node, and then click
Select All <node_name> Elements >
.//<node_name> on the shortcut menu.
To select the text that is associated with an element
node, right-click the node, click Select Text
on the shortcut menu, and then select one of the
choices on the submenu.
Query Result
This page shows the result of the XPath query that you
built on the XML Tree page.
View Source
This page shows the unformatted contents of the XML schema
or XML document that you selected as the source for the
XML pattern.
Verbose form pattern type
Select this check box to display the axis identifiers
in the location path.
Lock selection
Select this check box to define as the XML pattern
the location path that is currently shown in the
XML pattern field.
After selecting this check box, any nodes that you select
in the XML tree do not affect the defined XML pattern.
If you clear this check box after selecting another node,
the XML pattern changes to the currently selected node.
XML pattern
Shows the XPath expression for the location path that you
selected in the XML tree. If the Lock selection
check box is selected, this field shows the node that you
selected immediately before locking the selection.