G121: DB2 Version 5 to Version 7 Transition for Developers

TTFlogo2.gif (2585 bytes)

DB2 Version 5 to Version 7 Transitions for Developers - Topical Outline

Introduction - The Big picture

SQL changes
    New column functions
    New scalar functions
    Direct row access
    SET and VALUES INTO
    Row value expression
    UNION and UNION ALL extensions
    DECLARE VARIABLE
    Self-referencing subselects
    CONNECT - USER and USING
    ORDER BY extensions
Savepoints
    Computer Exercise: SQL Changes

Declared global temporary tables
Cursors
    Scrollable cursors
    SENSITIVE / INSENSITIVE cursors
    FETCH FIRST n ROWS ONLY
    Fast implicit close
    FOR UPDATE improvements
    Computer Exercise: Cursor Features

ODBC enhancements
Precompiler services
Global transactions
PLAN_TABLE changes
Optimization hints
DSN_STATEMENT_TABLE
Computer Exercise: PLAN_TABLE and EXPLAIN

Schemas
Stored procedures enhancements
    CREATE / ALTER / DROP PROCEDURE
    Security
    Invocation changes
    SYSROUTINES, SYSROUTINEAUTH, SYSPARMS catalog tables
    Computer Exercise: Stored Procedures

Programming environment changes
    DSNTEP2 in object form
    Improved query optimization
    New BIND options
Catalog table changes
New data types
    ROWID data type
    Identity columns
    LOBs
    Computer Exercise: New Data Types and Environment

Miscellaneous Changes
    DB2 extenders: Image, Video, Audio, Text, XML
    Predictive governing
    Triggers

Course Objectives
Course description
Home page