CONTENTS

  Title Page

  Copyright Page

  1      New Features and Technical Changes

  1.1     Ability to Update RMS Files

  1.2     Faster Response Time for Single Relation Queries

  1.3     The Index Key Optimizer

  1.4     Transaction Support
    1.4.1      Support for the RESERVING Clause
    1.4.2      Support for WAIT Options
    1.4.3      Using Transactions on VMS V5.3 Systems
    1.4.4      Using Transaction on VMS V5.4 and Later Systems
    1.4.5      Support for the Two-Phase Commit Protocol

  1.5     Hiding Columns In a Table

  1.6     Examining Product-specific Attributes From SQL

  1.7     Support for the OCCURS Clause

  1.8     Support for the COUNT (DISTINCT) Clause

  1.9     Copying Records from RMS Files to Rdb/VMS Databases

  1.10    Other Performance Improvements

  2      Software Errors Fixed

  2.1     Multisegment Keys

  2.2     Predicates with STARTING WITH

  2.3     Quad Word and Packed Decimal Indexes

  2.4     Displaying Database Keys From System Relations

  2.5     Retrieving Data From the System Relation RDB$DATABASE

  2.6     Join Order Not Optimal

  2.7     Nested Select Statements

  2.8     Record Definition Longer Than RMS Record Length

  2.9     Output to Decimal String Datatypes

  2.10    Optimal Timing of Selection

  2.11    Scaled Integer Scaling Change Problem

  2.12    Scaled Integer Problems

  2.13    The IS NULL Operator and Date Fields

  2.14    Tables With More Than 87 Fields

  2.15    Support for Markpoints

  2.16    Evaluation of LIKE

  2.17    Dictionary With Embedded Records and Structures

  2.18    Problems With Dictionary Definitions With Unsigned Datatype

  2.19    Comparing Constants

  2.20    Evaluating Queries with One Predicate on an Index Key Field

  3      Known Problems, Restrictions, and Other Notes

  3.1     RdbAccess for VAX RMS
    3.1.1      Prerequisite Software
    3.1.2      Transactions with the CONSISTENCY Clause
    3.1.3      Starting a Transaction on VMS 5.3 Systems
    3.1.4      Rollbacks on Sequential files
    3.1.5      Troubleshooting Remote Invocation
    3.1.6      Degree of Consistency Is Incorrect in RMS Data Driver User's Guide
    3.1.7      Remote RMS File and VSAM Considerations
    3.1.8      Record Locking Considerations
    3.1.9      Two-Byte Characters and Internationalization
    3.1.10     Diacritical Marks and Internationalization
    3.1.11     Remote Databases Versus Remote Files
    3.1.12     RMS File Specifications and Logical Names
    3.1.13     VARIANT Records in CDD/Repository Dictionaries
    3.1.14     Multifield Keys
    3.1.15     DMU Dictionaries
    3.1.16     Top-Down Dictionaries
    3.1.17     Delay on DECLARE SCHEMA or ATTACH Statement
    3.1.18     Large Collections for Complex Queries
    3.1.19     Unsupported Features for V2.0
    3.1.20     NSDS$DEBUG_FLAGS
    3.1.21     Diagnostic "E" Flag
    3.1.22     NSDS$OVERRIDE_TPB Value

  3.2     CDD/Repository
    3.2.1      Creation and Deletion of Files
    3.2.2      DAF$DRIVER_NAME
    3.2.3      CDD/Repository File Specifications and Logical Names
    3.2.4      CDD/Repository License
    3.2.5      CDD/Repository File Specification and Remote Files
    3.2.6      Use of CDO Command Files

  3.3     VAX SQL
    3.3.1      SQL V4.1 and ANSI-compliant Subqueries
    3.3.2      SQL V4.1 ATTACH statement problems
    3.3.3      SQL V4.0 Module Language and Precompiler Restriction
    3.3.4      Displaying Database Keys
    3.3.5      SQL/Services Server Process

  3.4     DECnet/SNA Data Transfer Facility (DTF)
    3.4.1      Index File Problem
    3.4.2      Resource Limitations

  3.5     Using DECquery on a Personal Computer

  3.6     VAX TEAMDATA and DECdecision
    3.6.1      VAX TEAMDATA and DECdecision Support
    3.6.2      Optional Patch for DECdecision Version 1.1
      3.6.2.1      Procedure for Applying the Patch
    3.6.3      Optional Patch for VAX TEAMDATA V1.4
      3.6.3.1      Procedure for Applying the Patch

  3.7     VAX Data Distributor
    3.7.1      Logical Names

  3.8     Digital Distributed Transaction Manager

  3.9     RALLY
    3.9.1      Using RDBaccess for VAX RMS with DEC RALLY

  TABLES

  3-1        NSDS$DEBUG_FLAGS Values