IBM Press - DB2 Stored procedures (2001).pdf - DB2 - darekisap

DB2 Stored Procedures:

Building and Debugging

Setting up the environment for DB2

Building DB2 stored procedures

Debugging DB2 stored

procedures

Maria Sueli Almeida

Marian Alcazar

Paolo Bruni

Sabine Kaschta

Mark Leung

ibm.com /redbooks

Cross-Platform

SG24-5485-01

International Technical Support Organization

Cross-Platform DB2 Stored Procedures:

Building and Debugging

May 2001

Take Note!

Before using this information and the product it supports, be sure to read the general information in

Appendix D, “Special notices” on page 497.

Second Edition (May 2001)

This edition applies to Version 6 of IBM DATABASE 2 Universal Database Server for OS/390 (DB2 UDB

Server for OS/390 Version 6), Program Number 5645-DB2, Version 7 of DB2 UDB for UNIX, Windows,

OS/2, IMS Version 6, Release 3 of CICS Transaction Server for OS/390, Program Number 5655-147,

and other current versions and releases of IBM products. Make sure you are using the correct edition

for the level product.

Comments may be addressed to:

IBM Corporation, International Technical Support Organization

Dept. QXXE Building 80-E2

650 Harry Road

San Jose, California 95120-6099

When you send information to IBM, you grant IBM a non-exclusive right to use or distribute the

information in any way it believes appropriate without incurring any obligation to you.

Note to U.S Government Users – Documentation related to restricted rights – Use, duplication or disclosure is

subject to restrictions set forth in GSA ADP Schedule Contract with IBM Corp.

Contents

Figures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii

Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix

Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi

The team that wrote this redbook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi

Comments welcome. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiii

Part 1. Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

Chapter 1. How this book is organized . . . . . . . . . . . . . . . . . . . . . . . . . . 3

The content . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

Part 2. Infrastructure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Chapter 2. The IBM DB2 Stored Procedure Builder . . . . . . . . . . . . . . . . 7

2.1 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

2.1.1 What is DB2 SPB? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

2.1.2 Programming languages supported . . . . . . . . . . . . . . . . . . . . . . . 9

2.2 Product Installation on Windows NT . . . . . . . . . . . . . . . . . . . . . . . . . . 10

2.2.1 Prerequisites for SPB . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

2.2.2 Installing the SPB . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

2.3 Advanced configuring of the SPB . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

2.4 Concepts and terminology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12

2.4.1 Project . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

2.4.2 Create . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

2.4.3 Generate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

2.4.4 Build . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

2.4.5 Register . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

2.4.6 Run . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

2.4.7 Get source . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

2.4.8 Modify . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

2.4.9 Dirty procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

2.4.10 Database connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

2.5 The SPB components. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

2.5.1 The stored procedure wizards . . . . . . . . . . . . . . . . . . . . . . . . . . 16

2.5.2 The SQL Assistant . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18

2.5.3 Client configuration assistant . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

2.5.4 IBM Distributed Debugger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

2.6 Working with SPB projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20

iii

IBM Press - DB2 Stored procedures (2001).pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: