 | Level: Intermediate Kirsten A. Larsen (kila@dk.ibm.com), Senior IT specialist, IBM
Susan Malaika, Senior Technical Staff Member, IBM
04 Jun 2009 In this tutorial, set up Web access to your pureXML data
through simple insert, update, delete, select, and query operations known as
the Universal Services. Use the included download bundle with ready-to-install
services to explore the concepts of this tutorial, and learn how to quickly
build application prototypes with the Universal Services.
Before you start
About this tutorial
This is the second installment in a
series
on how to get started with XML in IBM® DB2® for
z/OS®. This series provides different approaches for creating
simple applications that manipulate XML data. The objective is to
provide some familiarity with the technology and demonstrate the ease
with which XML applications can be developed, but the downloadable
material may also serve as a starting point for prototyping.
This tutorial describes how to set up Web access to your pureXML data
in DB2 for z/OS in a few easy steps, supplying a download bundle
complete with instructions for you to install.
The operations supplied are insert, update, delete, select, and query.
The query operation supplies the functionality of applying any XPath
expression entered through the Web page to your XML document in DB2,
thus providing an environment for experimenting with XPath as well as
a starting point for creating more specific queries.
This tutorial also provides instructions on how to import the Universal
Services into Data Studio as a project for further development.
The content in this tutorial is based on the article
"Universal Services for pureXML
using Data Web Services"
(developerWorks, August 2008). However, it has been adopted to target
DB2 for z/OS, whereas the original article works with DB2 for
Linux®, UNIX®, and Windows®.
Prerequisites
In order to install and run Universal Services, the following software
needs to be available:
- DB2 9 for z/OS
- JRE 1.5 or later on z/OS
- JDK 1.5 or later on the Windows server
- DB2 Connect, Version 8 or later
- This tutorial uses a type 4 JDBC driver, so DB2 Connect
does not actually need to be installed, but the license
must be available.
- One of the following Web servers:
- IBM WebSphere® Application Server, Version 7 or
later
- WebSphere Application Server Community Edition, Version
2.1 or later
- Apache Tomcat, version 5.5 or later
You can download both WebSphere Application Server Community Edition
and Tomcat free of charge (see
Resources).
| |
