IBM DB2 9.7 advanced application developer cookbook / Sanjay Kumar, Mohankumar Saraswatipura.

Format:

Book

Author/Creator:

Kumar, Sanjay.

Contributor:

Saraswatipura, Mohankumar.

Language:

English

Subjects (All):

IBM Database 2.

Relational databases.

Database management.

Physical Description:

1 online resource (442 p.)

Edition:

1st edition

Place of Publication:

Birmingham, U.K. : Packt Pub., 2012.

Language Note:

English

System Details:

text file

Summary:

This cookbook has recipes written in a simple, easy to understand format with lots of screenshots and insightful tips and hints. If you are an IBM DB2 application developer who would like to exploit advanced features provided by DB2 to design and implement high quality applications, then this book is for you. This book assumes you have a basic understanding of the DB2 application development.

Contents:

Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Application Development Enhancements in DB2 9.7; Introduction; Changing column names online using the ALTER TABLE operation; Using the CREATE OR REPLACE clause while creating objects; Using the ALTER TABLE operation in a single transaction; Using the CREATE WITH ERROR support; Using the soft invalidation and automatic revalidation support; Using the ALTER COLUMN SET DATA TYPE extended support; Using the new TRUNCATE statement; Using AUTONOMOUS transactions

Using implicit casting during application enablementUsing the DEFAULT values and NAMED arguments in procedures; Chapter 2: DB2 Application Techniques; Introduction; Granting and revoking instance-level authorities; Granting and revoking database-level authorities; Granting and revoking object privileges; Implementing static SQL in DB2; Implementing dynamic SQL in DB2; Creating Declared Global Temporary Tables (DGTTs); Using XML in a declared temporary table; Improving performance by creating indexes on a DGTT; Creating created global temporary tables (CGTT); Using generated columns in tables

Creating a savepointRolling back to a savepoint; Using savepoints in JDBC; Using savepoints in SQLJ; Creating a sequence object; Modifying a sequence object; Referencing a sequence object; Chapter 3: General Application Design; Introduction; Improving concurrency by using a connection concentrator; Using trusted contexts for improved security; Using trusted connections in JDBC; Using trusted connections in PHP; Securing data by using DB2 encryption; Improving concurrency by using enhanced optimistic locking; Working with user-defined types (UDT); Working with structured types

Chapter 4: Procedures, Functions, Triggers, and ModulesIntroduction; Creating a simple stored procedure; Using dynamic SQL in stored procedures; Working with result sets in stored procedures; Using ARRAY objects in stored procedures; Handling errors in stored procedures; Designing external stored procedures; Using PL/SQL exception handling in a procedure; Working with the message buffer in stored procedures; Planning and designing triggers; Using scalar user-defined functions; Writing external user-defined functions; Designing external table functions; Working with modules in DB2

Chapter 5: Designing Java ApplicationsIntroduction; Creating connection objects in JDBC applications; Creating connection objects in SQLJ applications; Manipulating XML Data in Java applications; Batch processing in JDBC applications; Batch processing in SQLJ applications; Working with scrollable result sets; Handling errors and warnings in JDBC applications; Developing Java applications for high availability; Using SSL in Java applications; Chapter 6: DB2 9.7 Application Enablement; Introduction; First step towards enabling Oracle application to DB2 9.7; Using ROWNUM and DUAL in DB2 9.7

Using CUR_COMMIT concurrency control isolation level

Notes:

Includes index.

ISBN:

9786613531216

9781280127335

1280127333

9781849683975

1849683972

OCLC:

781776610