---

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