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