|
V6 & V7 SQL Enhancements
 Processor
Time Estimates
Categories of
Estimates
Optimization Hints
IN Subselects Performance
Improvements
NOT IN Compared to NOT EXISTS
Update Based on Results of
Subselect
Method to Avoid Creating an
Ascending and  Descending
Index on the Same Column
DB2 Operations Without
Selecting from a 1
Row Table
in a Host Program
More SQL Enhancements
V6 & V7
Development Enhancements
Identity
Column
ROWID
Column
Scrollable
Cursors
Fetch
First n Rows Only
 UNION & UNION ALL in Views
Predicative Governor
for Dynamic SQL
Deleting Rows
During a Reorganization
REORG Unload
External and REORG Discard
And Then There is More
Triggering Actions in DB2
What are
Triggers
BEFORE Trigger to Validate Data
Activation Time and Events
Granularity
and Mode
Transition
Variables
|
|
WHEN
Conditions & Trigger Body
SIGNAL
SQLSTATE
Examples of
Trigger Usage
AFTER Triggers
Trigger
Package
Constraints & Triggers Contrasted
Stored
Procedures
Advantages of
Stored Procedures
Returning a Result Set
Procedures in
the Catalog Tables
SAVEPOINT Management
Access to
Non-DB2 Resources
Create & Declare Temporary Table
SQL Procedures
Procedural
Statements
Preparation of
Procedures
Procedure
Builder
User Defined Functions and Data Types
Creating and
Using Distinct Types
Cast To and From Distinct Types
Sourced and
External UDF
Explanation of
Create Function
Information
in the
Catalog
Table UDF
UDF Program
Preparation
Use of DSN_FUNCTION_TABLE
DB2 Supplied UDF
|
