DB2 Universal Database for OS/390 v7.1 Application Certification Guide |
By Susan Lawson |
| |
Publisher | : Prentice Hall PTR |
Pub Date | : November 26, 2002 |
ISBN | : 0-13-100771-8 |
Pages | : 624 |
Slots | : 2 | | | Copyright |
| | IBM DB2 Certification Guide Series |
| | Acknowledgments |
| | Preface |
| | | Part 1: Introduction to DB2 UDB for OS/390 and z/OS |
| | | 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 OS/390 and z/OS |
| | | 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. ODBC/CLI 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 |
| | | Tuning Guidelines |
| | | Access Paths and Optimization |
| | | Designing Indexes for Performance |
| | | Query Parallelism |
| | | Database Monitoring |
| | | Tracing Problems in DB2 |
| | | Using DISPLAY Commands |
| | | Summary |
| | | Additional Resources |
|
| | | Appendix A. IBM Certified Solutions ExpertDB2 UDB Family Application Development |
| | | Certification Test Objectives |
| | | Sample Test |
|
| | | Chapter B. Resources |
| | | DB2 Universal Database Server for OS/390 v7 Product Libraries |
|
| | | Chapter C. DB2CERT Database DDL |
|
| | Index |