DB2 Developers Guide (5th Edition) - page 1
- DB2 Developer s Guide
- DB2 Developer s Guide
- Table of Contents
- Copyright
- Accolades for DB2 Developer s Guide:
- About the Author
- Acknowledgments
- We Want to Hear from You
- What s New in This Edition?
- Introduction
- How To Use This Book
- Part I: SQL TOOLS, TIPS, AND TRICKS
- Chapter 1. The Magic Words
- An Overview of SQL
- SQL Tools of the Trade
- Static SQL
- Dynamic SQL
- SQL Performance Factors
- Chapter 2. Data Manipulation Guidelines
- A Bag of Tricks
- SQL Access Guidelines
- Complex SQL Guidelines
- Common Table Expressions and Recursion
- Working with NULLs
- Date and Time Guidelines
- Data Modification Guidelines
- Endnotes
- Chapter 3. Using DB2 Functions
- Column Functions
- Scalar Functions
- The RAISE_ERROR Function
- MQSeries Built-in Functions
- XML Publishing Built-in Functions
- Built-in Function Guidelines
- Chapter 4. Using DB2 User-Defined Functions and Data Types
- What Is a User-Defined Function?
- Types of User-Defined Functions
- What Is a User-Defined Data Type?
- User-Defined Data Types and Strong Typing
- Chapter 5. Data Definition Guidelines
- An Overview of DB2 Database Objects
- DB2 Databases
- Creating and Using DB2 Table Spaces
- DB2 Storage and STOGROUPs
- Table Guidelines
- Normalization and Denormalization
- Assuring Data Integrity in DB2
- Views, Aliases, and Synonyms
- Index Guidelines
- Naming Conventions
- Miscellaneous DDL Guidelines
- Chapter 6. DB2 Indexes
- Creating Indexes
- Index Guidelines
- Chapter 7. Database Change Management and Schema Evolution
- Online Schema Changes
- Chapter 8. Using DB2 Triggers for Integrity
- What Is a Trigger?
- Trigger Guidelines
- Chapter 9. Large Objects and ObjectRelational Databases
- Defining the Term
- What Is a Large Object?
- LOB Guidelines
- DB2 Extenders
- Chapter 10. DB2 Security and Authorization
- Granting and Revoking Privileges
- Part II: DB2 APPLICATION DEVELOPMENT
- Chapter 11. Using DB2 in an Application Program
- Embedded SQL Basics
- Embedded SQL Guidelines
- Host Variables
- Programming with Cursors
- Embedded SELECT and Cursor Coding Guidelines
- Modifying Data with Embedded SQL
- Application Development Guidelines
- Batch Programming Guidelines
- Online Programming Guidelines
- General SQL Coding Guidelines
- Chapter 12. Dynamic SQL Programming
- Dynamic SQL Performance
