CONTENTS

  Title Page

  Copyright Page

  Send Us Your Comments

  Preface

  1      About This MUP Release
    1.1 Problems Addressed In This MUP Release
    1.2 New Features

  2      New Features And Enhancements In V3.1
    2.1 Sybase Database As DBI Physical Database
    2.2 Explicit Join Operators
    2.3 Updatable Horizontally Partitioned Views
    2.4 Compound Statements
    2.5 Stored Procedures
    2.6 Derived Tables
    2.7 Support for ORACLE Rdb Version 6.1
    2.8 External (3GL) Function Callouts
    2.9 Insert From Query Expression
    2.10 Enhanced Run-time Partition Elimination
    2.11 Enhanced Join Implementations
    2.12 Enhanced Workspace Manager
    2.13 Parallel Query Execution
    2.14 Unnesting Of Some Nested Query Forms
    2.15 Query Governor And Optimization Level Logicals

  3      Differences Between DBI on OSF/1 and OpenVMS
    3.1 Client/Server Model
    3.2 No Two-phased Commit Capability On OSF/1
    3.3 OSF File Specifications In Attach, Link, and Proxy Syntax
    3.4 Configuration Parameters
    3.5 Trace Output Default Destination
    3.6 External Function Callouts

  4      Known Problems and Restrictions
    4.1 Restrictions
      4.1.1      Setting Up Your Environment To Access DBI
        4.1.1.1      Converting V1.0 DBI Databases For Use With DBI Version 3.1A
        4.1.1.2      Specifying SQL Authentication With Earlier Versions Of SQL
        4.1.1.3      Using DBI With SQL/Services On DEC OSF/1 AXP
        4.1.1.4      Parallelism Supported Only With Common Components V6.1
        4.1.1.5      Specifying Rdb Database Filenames As DBI Catalog
        4.1.1.6      Set Transaction Reserving Clause
      4.1.2      Using Data Manipulation Language
        4.1.2.1      Some Compound-use-statements Not Supported
        4.1.2.2      Module Authorization
        4.1.2.3      Segmented String Or List Cursor Support
      4.1.3      Using Data Definition Language
        4.1.3.1      Revoking Privileges From More Than One User
        4.1.3.2      Defining Functions On DEC OSF/1 AXP
        4.1.3.3      Defining Segmented String Columns In Pass-through Tables
    4.2 Known Problems
      4.2.1      General Usage
        4.2.1.1      Use Of Oracle As The Catalog Database And Oracle Gateway
      4.2.2      Using Data Manipulation Language
        4.2.2.1      Aggregates In Subqueries With An Outer Reference
        4.2.2.2      Fast First Optimization And Updatable Cursors
        4.2.2.3      Setting Query Limits
      4.2.3      Using Data Definition Language
        4.2.3.1      Revoking SELECT, Or (CREATE, DROP) Privileges When DBADM Privilege Is Also Present
        4.2.3.2      Revoke Operation May Cause Incorrect Loss Of Privileges

  5      Guidelines for Submitting a Quality Assurance Report (QAR)
    5.1 What To Include In The QAR
    5.2 Submitting A Documentation Reader's Comment Card