 | Level: Intermediate Debra R. Eaton (deaton@us.ibm.com), DB2 Software Information Technology Specialist, IBM
19 Oct 2006 The IBM® DB2® Developer Workbench (DWB) provides out-of-the-box
integrated development for DB2 9 pureXML. DWB is based on the Eclipse open
source Integrated Development Environment (IDE). Learn how the DWB resources,
perspectives, views, editors, and wizards assist you to work with the XML functionality in DWB.
Objectives - Learn how the DWB resources, perspectives, views, editors, and wizards assist you to work with XML.
- Become familiar with tasks such as creating, registering, and editing XML schemas,
creating XML instance documents from schemas, creating XML-related database objects
such as tables that contain XML data columns, and creating queries for XML data.
Prerequisites
You must install and configure the SAMPLE database that is included with DB2 9.1. See the DB2
product documentation and First Steps for more information. Ensure the SAMPLE database
is XML-enabled by specifying the XML option at database creation.See the Resources section of the tutorial for links to install DB2 and the Developer Workbench.
System requirements
To run the examples in this tutorial, you need to install DB2 9.1 and the SAMPLE database.
You must be able to connect to the SAMPLE database with a user ID and password. The schema used throughout this tutorial is DEATON. Replace the DEATON schema
with your schema, represented in the instructions by SCHEMANAME, when a task requires
a schema name.
Formats html, pdf
Tutorial overview
This tutorial takes a basic approach to working with XML in the DWB Eclipse
environment, starting by creating an XML table, schema and document, followed
by querying XML data with a stored procedure.
| | | |
