 | Level: Introductory Reginaldo Barosa (rbarosa@us.ibm.com), Senior Certified Application Development Specialist, IBM
05 Jul 2006 A stored procedure is a compiled program, stored on a DB2® local or remote server, that can execute SQL statements. This tutorial teaches how to use WebSphere® Developer for zSeries to create and test COBOL stored procedure, but PL/I users can follow the same steps.
Objectives
Using WebSphere Developer you will create a very simple database in the z/OS and, using the Data Perspective wizards, create a very simple COBOL DB2 stored procedure, and execute it. If you install the IBM Debug Tool for z/OS, you will be able to debug the DB2 COBOL Stored procedure.
Prerequisites
This tutorial is written for COBOL and PL/I programmers writing stored procedures to access DB2 data on z/OS. You don't need Java skills to take this tutorial.
System requirements
To complete this tutorial you need to install WebSphere Developer for zSeries v6.0.1 on your workstation, and install its mainframe components on z/OS. To create COBOL or PL/I OS/390 Stored Procedures, WebSphere Developer requires two connections to z/OS:
- One connection establishes a link between WebSphere Developer and the DB2 Universal Database server on z/OS, so that DB2 can display catalog information on tables, columns, stored procedures, etc., and perform operations (drop, import, sample contents, etc) on these DB2 assets.
- The second connection establishes a link between WebSphere Developer and z/OS, so that the generated stored procedure can be stored on and read from z/OS. This connection also allows you to work with your data sets.
You also need to install the IBM Debug Tool for z/OS on the z/OS machine. Note that the Debug Tool for z/OS is not part of WebSphere Developer for zSeries.
Duration
2 hours
Formats html, pdf
Summary
This tutorial teaches how too use the DB2 Stored Procedures Support for PL/I and COBOL in IBM WebSphere Developer for zSeries v6.0.1. It shows how to set up the development environment for stored procedures and how to work with COBOL stored procedure support.
This tutorial shows how to create, test and debug a COBOL DB2 stored procedure, but PL/I users can perform exactly the same steps using PL/I.
The main activities that you will perform are:
- Configure the DB2 database connection and workstation
- Create a test DB2 table for use in the stored procedure
- Connect to z/OS subsystems
- Create, build, test, and debug a COBOL stored procedure.
This tutorial employs animated examples to illustrate certain processes.
| | | |
