IBM Database Add-Ins for Visual Studio  

Creating DB2 XML Indexes

The IBM® Database Add-Ins for Visual Studio simplifies the process of creating DB2 XML indexes. You can use the IBM Table Designer tool to create an XML index. The designer generates the index as part of a table definition.

In the designer, you provide information about the index, specify the column for which you want to define the index, provide values for the properties of the XML index, and specify the XML pattern to use for the index.

To create an XML index by using the IBM Table Designer:

  1. Start creating a table or changing a table definition by using the IBM Table Designer.
  2. From the IBM Table Designer menu, select XML Indexes.

    The XML Indexes view of the IBM Table Designer is displayed.

  3. Add an index and define its XML column, properties, and XML pattern.

    For detailed information about fields in the XML Indexes view, see XML Indexes, Designer.

  4. Continue creating the table or changing the table definition.

See Also

Developing IBM Database Indexes | DB2 XML Indexes | Creating Relational Indexes


.NET Development Forum   DB2 FAQs

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