Book Image

IBM DB2 9.7 Advanced Application Developer Cookbook

Book Image

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

Working with modules in DB2


Modules were introduced in DB2 9.7, which provide a way to group together related database objects in a separate box. We can create a collection of different database objects and wrap them in a module. A module itself is a database object that can have different database objects in it. Objects that can be encapsulated in a module can be functions, stored procedures, user-defined types, and variables. Modules are typically used to group together the objects that serve a similar business purpose. For example, we can group together a set of functions and procedures that are useful for sales. We can manage a module, just like any other database object, making management easy. Modules provide ways to add and remove database objects in them. They also allow us to publish only selective objects from the module to users. In this recipe, we will discuss how we can create modules and how we can use them.

Getting ready

To create a module, we need at least one of the following...