Work with XML schemas in a DB2 database

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 indicate which elements are allowed in an XML file, and in which combinations. Use the Register an XML Schema wizard to register the XML schema on a DB2 database. You can then use the registered XML schema to validate the insertion or update of XML data into an XML column.

Learning objectives

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

Connect to the DB2 SAMPLE database and create a data development project to work with the database
Run a script to create additional tables in 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