Table of content
|
DB2 Universal Database for OS. 390 v7. 1 Application Certification Guide Authors: Lawson S. Published year: 2002 Pages: 1/163 |
 |
- Main
- 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
|
DB2 Universal Database for OS. 390 v7. 1 Application Certification Guide Authors: Lawson S. Published year: 2002 Pages: 1/163 |
|