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

Securing data by using DB2 encryption


Data encryption becomes very crucial in handling confidential data. Data can be encrypted during transit and at storage level. In this recipe, we will focus on encrypting the stored data. DB2 provides various functions that can be used to encrypt and decrypt the data. These functions can be embedded in any host language, just like a regular function or statement. Data is encrypted into BIT DATA, so before we can use encryption, we should have the target table designed to support the encrypted data.

Getting ready

We will use DB2 encryption functions to encrypt and decrypt the data in a test table. The following statement creates a test table that we will use in our recipe:

CREATE TABLE TEST_ENCRYPTION
(ID INTEGER,
NAME VARCHAR(30),
CONFIDENTIAL_INFO VARCHAR(100) FOR BIT DATA);

Because the encrypted data is BIT DATA, we need to define our target column as FOR BIT DATA.

How to do it...

In this recipe, we will see how we can use encryption functions provided...