What's New

Table of Contents

Welcome to DB2 Universal Database Version 7

Who Should Read This Book
How This Book Is Structured

Chapter 1. Introducing Version 7

Ease of Use
Launchpads
First Steps
Quick Tour
Information Center
Wizard Enhancements
Information Feedback
New Products and Packages
DB2 Warehouse Manager
QMF for Windows
DB2 Query Patroller
DB2 Relational Connect
Workgroup Edition on UNIX
DB2 OLAP Starter Kit
DB2 Spatial Extender
DB2 Net Search Extender
Application Development Client
Migration to Version 7
Migrating from Visual Warehouse Version 3.1 or Version 5.2

Chapter 2. e-business Enhancements

XML Extender Support
Net.Data Enhancements
Stored Procedures
Stored Procedure Builder
Nested Stored Procedure Support
SQL Procedure Language
Visual Basic Stored Procedures
Calling Stored Procedures
Stored Procedure Samples
Java Stored Procedure Class Loader

Chapter 3. Business Intelligence Enhancements

Data Warehouse Center
Star Schema Builder
Process Modeler
OLAP Capability
OLAP Starter Kit
Relational OLAP Capabilities
Business Intelligence Tutorial
Metadata Interchange
Heterogeneous Distributed Query
Query Patroller
QMF
Global Snapshot
Convert ODBC (Dynamic SQL) to Static SQL
Temporary Table Support
Object Relational Features
Structured Types
Transform Functions
SQL-bodied Functions
Typed Tables
User-Defined Extended Index Types
Replication
Data Links
Capture and Apply

Chapter 4. Data Management Enhancements

DB2 Data Links Manager
Native OLE DB Support
SQL Assist
Closing Log After Backup
On Demand Log Archive Support
Identity Column Support
Externalized Savepoint Support
Increase Log Limit to 32GB
Rename a Table Space

Chapter 5. DB2 Family Enhancements

Mobile Computing
Satellite Edition
DB2 Everywhere
>8 Character Userid Support
Pre-Version 7 Servers
Replication
OS/390
OS/400
Import and Export
Stored Procedures
LOAD Authority
USE OF TABLESPACE Authority
BIND Options
OS/390 in the Control Center
Generate DDL
OS/390 Utilities
DB2 Connect
Support DCL SNA Stack
XA Concentrator
Multisite Update Improvements
Windows 32-bit Operating Systems
Windows 2000
Visual C++ Application Development
Visual Studio Integration

Appendix A. Using the DB2 Library

DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online

Appendix B. Notices

Trademarks

Index

Contacting IBM

Product Information