Cross-platform db2 stored procedures: building and debugging
Maria Almeida, Marian Alcazar, Paolo Bruni, Sabine Kaschta, Mark Leung · IBM Corp. eBooks · 2001
Setting up the environment for DB2 Building DB2 stored procedures Debugging DB2 stored procedures This IBM Redbook documents a residency project conducted at the IBM International Technical Support Organization, San Jose Center. The project tested and implemented stored procedures executing in DB2 for OS/390, DB2 for Windows NT, DB2 UDB for AIX, and DB2 for AS/400 servers. This book covers the SQL Procedures language (which allows the customer to develop stored procedures in a standard and portable language across the DB2 family and OEM DBMSs), the IBM Stored Procedure Builder, and the IBM Distributed Debugger. It also explains how to implement DB2 stored procedures accessing non-DB2 resources. We developed and documented several sample stored procedure programs (available for downloading) to illustrate the theory discussed in this book. These programs are useful for getting started with the SQL Procedures language in your own environment and gaining some hands-on experience. This book is written for IBM technical professionals and customer technical personnel responsible for implementing stored procedures locally or in a client/server environment. A background in programming and Distributed Relational Database Architecture connectivity among IBM relational database products, and their associated operating systems, is assumed.