DB2 for z/OS Application Programming Topics

An IBM Redbooks publication

Abstract

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

Profile

Publish Date
31 October 2001


Rating: Not yet rated


Author(s)

ISBN-10
073842353X

ISBN-13
9780738423531

IBM Form Number
SG24-6300-00

Number of pages
286