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

60 minutes