DB2 for z/OS Application Programming Topics

An IBM Redbooks publication

Published 31 October 2001

cover image

ISBN-10: 073842353X
ISBN-13: 9780738423531
IBM Form #: SG24-6300-00
(286 pages)

Authors: Bart Steegmans, Rafael Garcia, Luis Garmendia, Anne Lesell


This IBM Redbooks publication describes the major enhancements that affect application programming when accessing DB2 data on a S/390 or zSeries platform, including the object-oriented extensions such as triggers, user-defined function and user-defined distinct types, the usage of temporary tables, savepoints and the numerous extensions to the SQL language, to help you build powerful, reliable and scalable applications, whether it be in a traditional environment or on an e-business platform.

IBM DATABASE 2 Universal Database Server for z/OS and OS/390 Version 7 is currently at its eleventh release. Over the last couple of versions a large number of enhancements were added to the product. Many of these affect application programming and the way you access your DB2 data.

This book will help you to understand how these programming enhancements work and will provide examples of how to use them. It provides considerations and recommendations for implementing these enhancements and for evaluating their applicability in your DB2 environments.

Table of contents

Chapter 1. Introduction
Part 1. Object-oriented enhancements
Chapter 2. Schemas
Chapter 3. Triggers
Chapter 4. User-defined distinct types (UDT)
Chapter 5. User-defined functions (UDF)
Chapter 6. Built-in functions
Part 2. Enhancements that allow a more flexible design
Chapter 7. Temporary tables
Chapter 8. Savepoints
Chapter 9. Unique column identification
Part 3. More powerful SQL
Chapter 10. SQL CASE expressions
Chapter 11. Union everywhere
Chapter 12. Scrollable cursors
Chapter 13. More SQL enhancements
Part 4. Utilities versus applications
Chapter 14. Utilities vs application programs
Part 5. Appendixes
Appendix A. DDL of the DB2 objects used in the examples
Appendix B. Sample programs
Appendix C. Additional material

Follow IBM Redbooks

Follow IBM Redbooks