You are previewing DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide.
O'Reilly logo
DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide

Book Description

  • IBM's definitive DB2 UDB V7.1 application development reference and exam study guide for the OS/390 and z/OS platforms

  • An official IBM self-study guide for the DB2 UDB V7.1 Family Application Development Exam (#514)

  • Expert DB2 programming tips, techniques, and guidelines from application development experts

  • Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and more

  • CD-ROM contains complete DB2 application development sample exam

  • The definitive, authoritative guide to DB2 OS/390 application development certification

  • Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and much more

  • Includes a full section on object-relational programming and other advanced techniques

  • Sample test questions help you prepare for the IBM DB2 UDB V7.1 Family Application Development Exam (#514)

  • About the CD

    The CD-ROM included with this book contains a complete DB2 UDB V7.1 Family Application Development Exam (#514) sample exam.

    IBM DB2 UDB Version 7.1 for OS/390 and z/OS delivers unparalleled performance, scalability, and reliability in today's enterprise business environments. Now, there's a complete, authoritative guide to developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments—and preparing for the IBM DB2 UDB V7.1 Family Application Development Exam (#514).

    This comprehensive day-to-day guide to DB2 UDB application development is also the only book that delivers the depth of knowledge professionals need to pass IBM's challenging application development exam for the OS/390 and z/OS platforms.

    IBM Gold Consultant Susan Lawson presents hundreds of useful tips, practical techniques, and expert guidelines for every facet of DB2 UDB application development and every stage of the development process for both OS/390 and z/OS platforms Coverage includes:

  • Foundations for effective DB2 development, including an overview of the DB2 UDB product family and DB2 for OS/390 data structures

  • SQL: basic concepts and coding techniques through advanced OLAP features, star schemas, and star joins

  • Stored procedures, including the SQL procedure language and IBM's Stored Procedure Builder

  • Best practices for application testing, debugging, and performance tuning

  • The full range of DB2 development tools, including ODBC/CLI, Java(tm), COBOL, C, C++, REXX, CAF, CICS, and RRSAF

  • Object-relational programming, including user-defined functions, user-defined data types, and triggers

  • In-depth coverage of locking and concurrency

  • Whether you're developing for DB2 UDB V7.1 in an OS/390 or z/OS environment, managing DB2 UDB V7.1 application development, preparing for DB2 UDB V7.1 Family Application Development, or all three, DB2 UDB for OS/390 Version 7.1 Application Certification Guide will be your single most valuable resource.

    IBM DB2 Series

    Table of Contents

    1. Copyright
    2. IBM DB2 Certification Guide Series
    3. Acknowledgments
    4. Preface
    5. Introduction to DB2 UDB for OS/390 and z/OS
      1. Product Overview
        1. DB2 and E-Business
        2. DB2 Universal Database
        3. DB2 Middleware and Connectivity
        4. DB2 Application Development
        5. DB2 Administration
        6. Data Management Tools
        7. Summary
        8. Additional Product Resources
      2. Database Objects
        1. Understanding Data Structures
        2. Managing Database Objects
        3. Database Design and Implementation
        4. Access to DB2 Objects
        5. Summary
        6. Additional Resources
    6. Structured Query Language
      1. Basic SQL Coding
        1. Data Retrieval
        2. Data Modification
        3. Summary
        4. Additional Resources
      2. Advanced SQL Coding
        1. Subqueries
        2. Unions
        3. Nested Table Expressions
        4. Joins
        5. CASE Expressions
        6. Row Expressions
        7. OLAP Features
        8. Summary
        9. Additional Resources
    7. Developing Applications
      1. Using SQL in an Application Program
        1. DB2 Application Development Environment
        2. Delimiting SQL in a Program
        3. Declaring Table and View Definitions
        4. Host Variables and Host Structures
        5. SQL Execution Validation
        6. Using Cursors
        7. Using Dynamic SQL
        8. Summary
        9. Additional Resources
      2. Binding an Application Program
        1. Precompile and Bind
        2. Plan or Package Ownership
        3. Summary
        4. Additional Resources
      3. Application Program Features
        1. Application Program Features
        2. Commit, Rollback, and Savepoint
        3. Global Transactions
        4. Global Temporary Tables
        5. Fetch for Limited Rows
        6. Identity Columns
      4. Stored Procedures
        1. Stored Procedures
        2. Benefits
        3. Writing Stored Procedures
        4. Defining Stored Procedures
        5. Execution Environments
        6. SQL Procedure Language
        7. Stored Procedure Builder
        8. Summary
        9. Additional Resources
      5. Testing and Debugging Applications
        1. Establishing a Test Environment
        2. Debugging Application Programs
        3. Locating the Problem
        4. Testing and Debugging Stored Procedures
        5. Summary
        6. Additional Resources
      6. Accessing Distributed Data
        1. Distributed Data
        2. Coding Methods for Distributed Data
        3. Programming Considerations
        4. Remote Query Performance
        5. Summary
        6. Additional Distributed Resources
    8. Programming and Language Environments
      1. ODBC/CLI Programming
        1. Embedded Dynamic Versus Call-Level Interface
        2. The DB2 ODBC Environment
        3. Handles
        4. Database Connections
        5. Transaction Control
        6. Executing SQL Statements
        7. Retrieving Results
        8. ODBC Stored Procedures
        9. Error Handling and Problem Determination
        10. Sample Program
        11. Summary
        12. Additional Resources
      2. DB2 Traditional Programming
        1. COBOL
        2. C and C++
        3. REXX
        4. Summary
        5. Additional Resources
      3. Java Programming
        1. DB2 and Java
        2. JDBC
        3. SQLJ
        4. Design Guidelines for Applications
        5. Java Stored Procedures and UDFs
        6. Summary
        7. Additional Resources
      4. Attachment Programming
        1. Attachments
        2. TSO
        3. CICS
        4. IMS
        5. Call Attachment Facility
        6. RRSAF
        7. Summary
        8. Additional Resources
    9. Advanced Programming Functions
      1. Object-Relational Programming
        1. Triggers
        2. Object-Relational Extensions
        3. Extenders
        4. LOB and Extender Usage
        5. Enabling Extenders
        6. Summary
        7. Additional Resources
      2. Locking and Concurrency
        1. Locking Data
        2. Avoiding Locks
        3. System Parameters
        4. Claims and Drains
        5. Locking Issues and Problems
        6. Summary
        7. Additional Resources
      3. Application Performance and Optimization
        1. Elements of Performance
        2. Tuning Guidelines
        3. Access Paths and Optimization
        4. Designing Indexes for Performance
        5. Query Parallelism
        6. Database Monitoring
        7. Tracing Problems in DB2
        8. Using DISPLAY Commands
        9. Summary
        10. Additional Resources
      4. IBM Certified Solutions Expert—DB2 UDB Family Application Development
        1. Certification Test Objectives
        2. Sample Test
      5. Resources
        1. DB2 Universal Database Server for OS/390 v7 Product Libraries
      6. DB2CERT Database DDL
    10. Index