Skip to main content

DB2 for z/OS Application Programming Topics

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 31 October 2001

  1. .PDF (3.1 MB)

Share this page:   

ISBN-10: 073842353X
ISBN-13: 9780738423531
IBM Form #: SG24-6300-00

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

    menu icon


    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


    Others who read this also read