Before you start
With the popularity of SOA and Web-based technologies, there are increasing amounts of XML data coming in and out of computer systems. The IBM DB2® 9 for z/OS® support for pureXML® makes it much simpler to store and manipulate XML on System z® through SQL/XML interfaces. This tutorial is the third installment in a series on how to get started with XML in DB2 for z/OS. The series provides different approaches for creating simple applications that manipulate XML data. The first installment presents an example application based on COBOL stored procedures that can be downloaded. The second installment shows how to set up Web access through Universal Services.
This tutorial describes how to use Rational Developer for System z to develop COBOL stored procedures that manipulate XML data. This tutorial shows the XML schema support offered, and provides step-by-step instructions for creating and testing stored procedures.
The objective of this tutorial is to demonstrate the ease with which COBOL applications for handling pureXML in DB2 can be developed using Rational Developer for System z (RDz).
This tutorial is written for COBOL developers whose skills and experience are at an introductory to intermediate level. You should have a general familiarity with XML and a working knowledge of DB2 for z/OS.
You need to have the following software installed on z/OS:
- DB2 9 for z/OS
- IBM Enterprise COBOL for z/OS 4.1.0
- Rational Developer for System z, Version 7.5 server
You need to have the following software installed on your laptop:
- Rational Developer for System z, Version 7.5 client
This tutorial assumes that you have already configured RDz on both the server and client sides, that you have created a connection to z/OS, and that you have the authorizations required to perform the necessary tasks. see the Resources section for links to trial download and documentation.