DB2 Version 7 Differences - Topical Outline

Introduction    
   The Big picture
   Migration basis
The Sample Application
SQL changes
UNION and UNION ALL extensions
DECLARE VARIABLE
Variations on SET
CONNECT - USER and USING
ORDER BY extensions
Self-referencing subselects
SQL procedures IN and OUT parameters
Alternative Date/time functions
   Computer Exercise: SQL Changes

Programming Environment changes
Cursors
Scrollable cursors
SENSITIVE / INSENSITIVE cursors
FETCH FIRST n ROWS ONLY
Fast implicit close
FOR UPDATE improvements
Declared global temporary tables
SELECT INTO extensions
UPDATE / DELETE / INSERT extensions
PLAN_TABLE and DSN_STATEMENT_TABLE changes
ODBC enhancements
Improved query optimization
New BIND options - ENCODING
Stored Procedures enhancements
Precompiler services
Global transactions
   Computer Exercise: Programming Environment Changes

Data Base Administration Enhancements
DBADM authority increase
Changes in creating, maintaining, and deleting primary keys,
     foreign keys, unique keys, and check constraints
Unicode / CCSID option
CREATE DATABASE
CREATE DISTINCT TPE
CREATE FUNCTION / PROCEDURE
CREATE GLOBAL TEMPORARY TABLE
CREATE TABLE
View definitions
SQL scalar functions: CREATE / ALTER / DROP FUNCTION
ALTER PROCEDURE
ALTER TABLE
COMMENT ON
GRANTs and REVOKEs for JAR privileges
   Computer Exercise: Data Base Administration Changes

Utility Enhancements
    Utility packaging
    New utility control statements: EXEC SQL, LISTDEF, TEMPLATE, OPTIONS
    New utilities: COPYTOCOPY, MODIFY STATISTICS, UNLOAD
    Enhanced utliities: LOAD, REBUILD INDEX, REORG INDEX,
REORG TABLESPACE, RUNSTATS
   Computer Exercise: Utilities Changes

Command Enhancements
    New commands: SET SYSPARM, DISPLAY DDF
    Enhanced commands: CANCEL THREAD, DISPLAY THREAD, MODIFY irlm
RECOVER POSTPONED, SET LOG, START DB2, START irlm
   Optional Computer Exercise: Command Changes

Miscellaneous Changes
Catalog table changes
Online subsystem parameter modification
Object availability after failed transactions
Log-read retry
Data sharing enhancements
XML Extender
Connectivity enhancements
Cross-enterprise enhancements
    Warehouse Center
    Management Clients Package
    Net Search Extender
    Net.data

Course information: G-120 / 2 Days   These Materials © Copyright 2001 by Hunter Cobb    V1.x

Course Objectives
Course description
Home page

this page last updated: 01 June, 2004
this page copyright © 2004 by The Trainer's Friend, Inc.