CONTENTS

  Title Page

  Copyright Page

  Send Us Your Comments

  Preface

  1      New and Changed Features
    1.1 Improved MDI Image Activation Error Handling for Version 3.0D
    1.2 New Metadata Driver for Version 3.0C
      1.2.1      Features of the New Metadata Driver
      1.2.2      CDO Reader Metadata Driver Debug Flags
      1.2.3      Behavioral Differences from the CDD/Repository Metadata Driver
      1.2.4      CDO Syntax Considerations of New Driver
    1.3 Installation Overview for Version 3.0B
    1.4 Change in Behavior for Files Without RMS JOURNALING
    1.5 Two Products Share Common Media and Some Documentation
    1.6 Each Product Is Now Available on Two Platforms
    1.7 Installation Instructions for AXP Sites
    1.8 RMS Indexes Used to Execute Joins Optimally
    1.9 STARTING WITH Predicate Used to Join Tables
    1.10 Data Driver Calls to Define Access Paths Changed
    1.11 Changes to Existing Drivers
    1.12 Use of Segmented Keys Extended and Enhanced
    1.13 RDB$FLAGS and RDB$FIELD_VERSIONS Supported
    1.14 Active Field Lists Now Available for Data Drivers

  2      Software Errors Fixed
    2.1 Failure to handle OCCURS clause in distributed dictionaries
    2.2 Access violation in DBMS gateway
    2.3 Problem with keyed access to date fields
    2.4 Improved handling of naming rule violations in Custom Driver applications
    2.5 Restriction on entity names for Custom Drivers
    2.6 Access violation in CDO Reader
    2.7 Problem with error diagnostic in CDO Reader Metadata Driver
    2.8 Gateway ATTACH fails When Using V6.1 Common Components
    2.9 Problem With ``Invalid Transaction Handle''
    2.10 Precision Problem with D_FLOATING
    2.11 Problem with Microsoft ACCESS and Segmented Keys
    2.12 Files with Multiple Keys with the Same Offset
    2.13 Error Returned On Cross-Database Join
    2.14 Missing Read/Write Override for Nonjournaled, Nonindexed Files
    2.15 Problem with Duplicate Literal Values
    2.16 Problem with Driver Activation Error Handling
    2.17 Spurious Error Message Generated
    2.18 Link of Sample DDI Driver Failed in the Gateway for Custom Drivers Version 3.0A
    2.19 RDB$INDICES and RDB$INDEX_SEGMENT Support Added for Products Requiring a Unique Key
    2.20 Auxiliary Access Paths Built for Dynamic and Embedded SQL Queries
    2.21 Queries That Select Large Data Sets Execute Faster
    2.22 Problem with Queries That Retrieve Large Data Collections Corrected
    2.23 Limitation on Segmented Keys Removed
    2.24 Problem with Multiplication Operations on Large Integer Values Corrected
    2.25 RMS Lock on Last Record Now Released
    2.26 Sample Driver Build Files Now Build DEBUG Images
    2.27 Negated Predicates Evaluated Correctly
    2.28 LIKE Predicates Evaluated Correctly
    2.29 Queries Can Now Use Access Paths to Access Remote Files
    2.30 SQL String Concatenation Operator Now Produces Expected Output
    2.31 Certain Large TEXT Keys Generate Access Violation
    2.32 Problems with SQL CAST Function in Rdb/VMS V4.2
    2.33 NSDS Interprets Spaces Correctly When Converting Text with SQL CAST Function
    2.34 SQL CAST Function Converts Text Fields to Scaled Integer Data Formats Correctly
    2.35 SQL List Cursors and RMU/EXTRACT Generate Correct Output
    2.36 Cursor Updates No Longer Fail After Multiple FETCH Statements
    2.37 Attempts to Open Multiple Cursors No Longer Fail
    2.38 First of Two Identical Cursors No Longer Returns Incorrect Data
    2.39 Bugchecks on Certain Multirelation Queries Corrected
    2.40 Dbkey Retrieval from Multiple Relations Corrected
    2.41 SMALLINT or TINYINT Fields No Longer Compared as Unsigned Integers
    2.42 Memory Leaks Reduced Significantly
    2.43 RESERVING Clause Problem in DECLARE TRANSACTION with VAX Rdb/VMS SQL Version 4.2 and Higher

  3      Known Problems, Restrictions, and Other Notes
    3.1 Known Problems for the Gateways for Custom Drivers and RMS
      3.1.1      CDO Driver Restrictions
      3.1.2      Documentation Error in Accessing RMS and VSAM Files with SQL
      3.1.3      Sample DDI Driver Might Fail for Gateway for Custom Drivers on Early Version of OpenVMS on VAX
      3.1.4      Factors Influencing Performance
      3.1.5      You Must Be Consistent in Using Logical Names for Assigning Drivers to Relations on OpenVMS AXP Systems
      3.1.6      Error Results from Mismatched Protocol Numbers
      3.1.7      Limit on Number of Data Bytes in a Single Table
      3.1.8      Unique Names Required for Fields in Embedded Structures
      3.1.9      NSDS Will Not Reopen Cursor If Open Fails
      3.1.10     NSDS May Lose Precision Evaluating D_FLOAT Data on OpenVMS AXP Systems
      3.1.11     NSDS May Lose Precision Evaluating H_FLOAT Data on OpenVMS AXP Systems
      3.1.12     Floating-Point Data Conversion Causes Precision Loss
      3.1.13     NSDS Sometimes Truncates Instead of Rounding Values of Fixed-Point Integers
      3.1.14     NSDS Uses ASCII Collating Sequences
      3.1.15     DEC DB Integrator Gateway for Custom Drivers and DEC DB Integrator Gateway for RMS Do Not Support All DEC Rdb S
      3.1.16     Complex Queries May Produce Incorrect Results
      3.1.17     RALLY Cannot Access Non-VSAM IBM Files
      3.1.18     INSERT Statement That Includes SELECT from Same Row May Fail
      3.1.19     Multiple Data Driver Names Cause RMS Journaling Problem
      3.1.20     Problem Recovering from Multiple Database Transaction Error
      3.1.21     Transactions with the CONSISTENCY Clause
      3.1.22     Starting a Transaction on OpenVMS Version 5.3 Systems
      3.1.23     Rollbacks on Sequential Files
      3.1.24     Troubleshooting Remote Invocation
      3.1.25     Remote RMS File and VSAM Considerations
      3.1.26     Record Locking Considerations
      3.1.27     Two-Byte Characters and Internationalization
      3.1.28     Diacritical Marks and Internationalization
      3.1.29     Remote Databases Versus Remote Files
      3.1.30     RMS File Specifications and Logical Names
      3.1.31     VARIANT Records in CDD/Repository
      3.1.32     DMU Dictionaries
      3.1.33     ``Top-Down'' Repositories
      3.1.34     Delay on DECLARE SCHEMA or ATTACH Statement
      3.1.35     Limit Selection for Faster Query Processing
      3.1.36     Unsupported Features
      3.1.37     FILLER Fields Created Using DATATRIEVE Cause Bugcheck
    3.2 Known Problems and Restrictions for CDD/Repository
      3.2.1      Complex Index Definitions May Not Be Shown
      3.2.2      License Problem During CDD/Repository Installation
      3.2.3      Creating and Deleting Files with CDO
      3.2.4      DAF$DRIVER_NAME Changed to NSDS$DRIVER_NAME
      3.2.5      CDD/Repository File Specifications and Logical Names
      3.2.6      Diagnosing CDD/Repository Metadata Problems
      3.2.7      CDD/Repository File Specifications and Remote Files
      3.2.8      Using CDO Command Files
      3.2.9      Storing VSAM Records in CDD/Repository
      3.2.10     Using CDO Edit Strings
      3.2.11     Defining Embedded Structure in CDD/Repository
    3.3 Known Problems and Restrictions for SQL
      3.3.1      Default Transaction Behavior Changed for NSDS Databases
      3.3.2      SQL Version 4.1 ATTACH Statement Problems
      3.3.3      Displaying Database Keys
      3.3.4      SQL SELECT Statement LIMIT TO Clause Support Restricted
      3.3.5      Decimal String Data May Generate Exception
      3.3.6      SUM Function for Decimal String Data Types (or SMALLINT) Can Fail
      3.3.7      Restriction for SQL Module Language and SQL Precompiler Applications Run with Rdb/VMS V4.0
      3.3.8      SQL Module Language Modules with Multiple Updates on Single Cursor Unsupported
      3.3.9      SQL/Services Server Process
    3.4 Known Problems and Restrictions for DEC ODBC Driver V1.0 for Microsoft Windows
    3.5 Known Problems and Restrictions for DECnet/SNA Data Transfer Facility
      3.5.1      Index File Problem
      3.5.2      Resource Limitations
      3.5.3      Restriction Affecting /RECORD_DEFINITION Qualifier
    3.6 Known Problems and Restrictions for Data Distributor
      3.6.1      Logical Names
      3.6.2      Data Distributor Support for DEC Rdb Versions
      3.6.3      Data Distributor Produces DEC Rdb Database Files Only
    3.7 Known Problems and Restrictions for Digital Distributed Transaction Manager
    3.8 Known Problems and Restrictions for RALLY
      3.8.1      Using The Gateway for RMS with RALLY
      3.8.2      RALLY Cannot Access Non-VSAM IBM Files

  4      Documentation Additions and Changes
    4.1 SQL Statements Not Supported by NSDS
    4.2 Usage of DDI Functions
    4.3 Access Paths
      4.3.1      Relationship Between Primary and Auxiliary Access Paths
      4.3.2      Using Primary and Auxiliary Access Paths
    4.4 API Modifications for Version 3.0
      4.4.1      VAX and IBM datatypes Clarified

  NSDS$MDI_INI

  Index Callback Function

  Index Segment Callback Function

  NSDS$DDI_INI

  DDI Access Path Callback Function
    4.5 Troubleshooting Problems with Writable Shareable Images
    4.6 Errors in the Gateway for Custom Drivers Driver Development Guide
    4.7 Clarification of Recovery-Unit Journaling Documentation
    4.8 Additional Information for Accessing RMS and VSAM Files with SQL
      4.8.1      Improving Performance for Large Files
      4.8.2      Edit Strings Supported by DEC DB Integrator Gateway for RMS

  A How to Order Additional Documentation