With the IBM^® Database Add-Ins for Visual Studio, you can define SQL routine parameters and columns in DB2^® database objects to be of data type XML. You can include XML documents as input and output parameters to SQL procedures and functions. You can also store XML documents as data in columns of DB2 database tables and views.

This section provides conceptual information and instructions for using the add-ins to store and process XML data in your DB2 database.

In this section:

Registering XML Schemas in the XML Schema Repository

Instructions for registering XML schemas so that they can be used for validating XML data and generating sample XML data.

DB2 XML Indexes

Conceptual information about DB2 XML indexes.

Creating DB2 XML Indexes

Instructions for adding a new XML index to a DB2 table definition.

Reviewing XML Data in DB2 Tables and Views

Instructions for examining the XML data that is stored in DB2 tables and views.

Importing XML Data to DB2 Tables and Views

Instructions for adding XML documents as data in columns of DB2 tables and views.

Changing XML Data in DB2 Tables and Views

Instructions for changing XML data that is stored in DB2 tables and views.

Validating XML Data in DB2 Tables and Views

Instructions for validating XML documents to ensure that the data conforms to the structure that is defined in an XML schema.

Transforming XML Data

Instructions for transforming the source structure of an XML document into a different result structure.

Deleting XML Data from DB2 Tables and Views

Instructions for deleting an XML document that is stored in a column in a DB2 table or view.

.NET Development Forum   DB2 FAQs

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