DB2 Universal Database for OS. 390 v7. 1 Application Certification Guide

DB2(R) Universal Database for OS/390 V7.1 Application Certification Guide (IBM DB2 Certification Guide Series)

ISBN: 0131007718
EAN: 2147483647

Year: 2002
Pages: 163

Authors: Susan Lawson

BUY ON AMAZON

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