IBM DB2 9.7 advanced application developer cookbook
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 i...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | Inglés |
| Published: |
Birmingham, U.K. :
Packt Pub
2012.
|
| Edition: | 1st edition |
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628115606719 |
Table of 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
