舉報 
會員
IBM DB2 9.7 Advanced Application Developer Cookbook
最新章節：
Index
Thiscookbookhasrecipeswritteninasimple,easytounderstandformatwithlotsofscreenshotsandinsightfultipsandhints.IfyouareanIBMDB2applicationdeveloperwhowouldliketoexploitadvancedfeaturesprovidedbyDB2todesignandimplementhighqualityapplications,thenthisbookisforyou.ThisbookassumesyouhaveabasicunderstandingoftheDB2applicationdevelopment.
目錄(111章)
倒序
- coverpage
- IBM DB2 9.7 Advanced Application Developer Cookbook
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- 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 enablement
- Using 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 savepoint
- Rolling 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 Modules
- Introduction
- 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 Applications
- Introduction
- 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
- Implementing hierarchical queries for recursion support
- Using PL/SQL ANONYMOUS block statements
- Handling RAISE_APPLICATION_ERROR in DB2 PL/SQL
- Migrating Oracle database objects on to DB2 9.7
- Porting multi-action triggers from Oracle to DB2 9.7
- Chapter 7. Advanced DB2 Application Features and Practices
- Introduction
- Working with OLAP functions
- Using optimizer profiles
- Using explain utilities
- Using section explain information
- Interpreting db2exfmt output
- Application development in partitioned databases
- Chapter 8. Preparing and Monitoring Database Applications
- Introduction
- Preparing applications for execution
- Rebinding existing packages
- Customizing application behavior using registry variables
- Monitoring application performance
- Chapter 9. Advanced Performance Tuning Tips
- Introduction
- Understanding predicates in SQL statements
- Improving INSERT performance
- Writing effective SQL statements
- Index 更新時間：2021-08-20 15:42:38
推薦閱讀
- C++ Primer習題集（第5版）
- UNIX編程藝術
- Python入門很簡單
- C#完全自學教程
- Java開發入行真功夫
- 你不知道的JavaScript（中卷）
- AutoCAD VBA參數化繪圖程序開發與實戰編碼
- C# 8.0核心技術指南（原書第8版）
- Learning Concurrency in Kotlin
- 深入淺出React和Redux
- 新一代SDN：VMware NSX 網絡原理與實踐
- Scala Data Analysis Cookbook
- Frank Kane's Taming Big Data with Apache Spark and Python
- Learning YARN
- Hands-On Full Stack Development with Spring Boot 2.0 and React
- Xamarin Blueprints
- Mockito Essentials
- Data Science Algorithms in a Week
- 大數據時代的企業升級之道（全3冊）
- 軟技能2：軟件開發者職業生涯指南
- Tkinter GUI Programming by Example
- LabVIEW虛擬儀器項目開發與實踐
- Lua Quick Start Guide
- 超簡單：用Python讓Excel飛起來·核心模塊語法詳解篇
- Learning Go Web Development
- 同構：編程中的數學
- UX for the Web
- Unity 2018 Artificial Intelligence Cookbook（Second Edition）
- 名師講壇：Java開發實戰經典（第2版）
- Mastering Symfony
