DB2 9.7 introduced a new type of temporary table: Created Global Temporary Table, also known as CGTT. The purpose of using a created global temporary table is the same as a declared global temporary table, which is to store the intermediate results within an application. There are some key differences between the two. The biggest difference between a CGTT and a DGTT is the existence in system catalogs. The definition of the created global temporary tables are stored in system catalogs, while it's not done for a DGTT. The content of a CGTT is still private to a session. Because the definitions of a CGTT is present in system catalogs, it persists. The advantage of its persistence is that it is usable in functions, procedures, and so on. Also, we don't need to declare the table every time in our application before using it. In this recipe, we will see how to create a created global temporary table (CGTT).
IBM DB2 9.7 Advanced Application Developer Cookbook
IBM DB2 9.7 Advanced Application Developer Cookbook
Overview of this book
With lots of new features, DB2 9.7 delivers one the best relational database systems in the market. DB2 pureXML optimizes Web 2.0 and SOA applications.
DB2 LUW database software offers industry leading performance, scale, and reliability on your choice of platform on various Linux distributions, leading Unix Systems like AIX, HP-UX and Solaris and MS Windows platforms. This DB2 9.7 Advanced Application Developer Cookbook will provide an in-depth quick reference during any application's design and development.
This practical cookbook focuses on advanced application development areas that include performance tips and the most useful DB2 features that help in designing high quality applications. This book dives deep into tips and tricks for optimized application performance.
With this book you will learn how to use various DB2 features in database applications in an interactive way.
Table of Contents (15 chapters)
IBM DB2 9.7 Advanced Application Developer Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Application Development Enhancements in DB2 9.7
DB2 Application Techniques
General Application Design
Procedures, Functions, Triggers, and Modules
Designing Java Applications
DB2 9.7 Application Enablement
Advanced DB2 Application Features and Practices
Preparing and Monitoring Database Applications
Advanced Performance Tuning Tips
Customer Reviews