Create and register an XML schema on DB2

This tutorial teaches you how to create and register an XML schema on DB2. You can create an XML schema and then edit it using the XML schema editor. Using the XML schema editor, you can specify element names that indicates which elements are allowed in an XML file, and in which combinations. Use the Register an XML Schema wizard to register an XML schema on a DB2 database. From the Table editor, you can then validate XML data against a registered XML schema that is used for decomposition.

Learning objectives

When you complete the exercises, you will know how to do the following tasks:

Connect to the XMLDB database and create a Data Development project to work with the database
Use the XSD editor to create an XML document for your XML schema
Register the XML schema
Use the XML schema to validate XML column data

This tutorial should take approximately 60 minutes to finish. If you explore other concepts related to this tutorial, it could take longer to complete.

Skill level

Advanced

Audience

Database developers

System requirements

You must install and configure the a UTF -8 database. From the DB2 Command Line Processor, run the following command:
db2 create db xmldb using codeset utf8 territory us

The name of the database is XMLDB. The territory identifier shows the code that is used by the database manager internally to provide region-specific support. All territory codes are supported. In the command above, the territory identifier is the United States. In order to create the database, you must have SYSADM or SYSCTRL authorization.

Prerequisites

In order to complete this tutorial, you should be familiar with the following concepts:

Database development
XML schemas

Lessons in this tutorial

Creating a connection to the XMLDB database
The workbench provides wizards that make it easy for you to connect to both DB2 and non-DB2 databases and to display the status of your connections. The New Connection wizard creates a connection to a database that is displayed in the Database Explorer view. Using the view, you have the option to create a DB2 database connection. For the purposes of this tutorial you connect to the XMLDB database.
Creating a project for XML schema development
Before you create database objects, you must create a Data Development project in which to work with them.
Creating an XML schema document
Use the XSD editor to create an XML document for your XML schema. The XML document is used to define the XML schema. XML schemas must contain one or more XML schema documents.
Registering the XML schema
Using the Register an XML Schema wizard, you can register an XML schema to the DB2(R) database server. The XML schema will be used to validate XML column data by using the Table editor.
Using the XML schema to validate XML column data
Use the XML schema to validate XML column data.