CONTENTS

  Title Page

  Copyright Page

  Preface

  1      Overview of RdbAccess for VAX RMS

  1.1     Using RdbAccess for VAX RMS

  1.2     How RdbAccess for VAX RMS Works
    1.2.1      The RMS Data Driver
    1.2.2      The Dictionary Driver

  1.3     How RdbAccess for VAX RMS Works with Other Software Products
    1.3.1      VAX SQL
    1.3.2      Rdb/Dispatch
    1.3.3      CDD/Plus
    1.3.4      DECnet/SNA VMS Data Transfer Facility (DTF)

  1.4     Types of Data that RdbAccess for VAX RMS Can Retrieve

  2      Using VAX SQL with RdbAccess for VAX RMS

  2.1     Getting Help

  2.2     Determining Eligibility of the RMS data file

  2.3     Creating Data Definitions
    2.3.1      Defining Fields
    2.3.2      Defining Records
    2.3.3      Defining a Logical Database
    2.3.4      Defining a Physical Database
    2.3.5      Defining a Physical Database for an Existing Data File
    2.3.6      Specifying the Data Driver Image

  2.4     Including SQL Statements in Programs
    2.4.1      Programs Using Precompiler Support
    2.4.2      Programs Using the Module Processor
    2.4.3      Using SQL/Services with RdbAccess for VAX RMS

  2.5     Using Interactive SQL

  2.6     Accessing Data with RdbAccess for VAX RMS
    2.6.1      Using the DECLARE SCHEMA FILENAME Statement
    2.6.2      Getting Information About Databases
    2.6.3      Defining SQL$DATABASE

  2.7     Detaching from RdbAccess for VAX RMS

  2.8     Declaring Transactions

  2.9     Setting the Collating Sequence

  2.10    Setting the Decimal Point

  2.11    Using RdbAccess for VAX RMS With Other Software
    2.11.1     Using DECdecision Access with RdbAccess for VAX RMS
    2.11.2     Using TEAMDATA with RdbAccess for VAX RMS
    2.11.3     Using VAX Data Distributor with RdbAccess for VAX RMS

  2.12    Security Considerations

  3      Reading VSAM Data Sets with RdbAccess for VAX RMS

  3.1     Accessing VSAM Data Sets with RdbAccess for VAX RMS
    3.1.1      Specifying a VSAM Data Set
    3.1.2      Creating a Proxy Database

  3.2     Reading VSAM Data Sets with RdbAccess for VAX RMS and DTF

  3.3     Determining Eligibility of VSAM Data Sets

  3.4     Installing DTF

  3.5     Creating Data Definitions for the VSAM Data Set
    3.5.1      Using DEFINE RMS_DATABASE
    3.5.2      Using the DEFINE DATABASE Command with an Existing Data Set

  3.6     Defining Attributes for RdbAccess for VAX RMS

  3.7     Including SQL Statements in Programs

  3.8     Using Interactive SQL with VSAM Data Sets

  3.9     Securing DTF

  4      A Sample of RdbAccess for VAX RMS Use

  4.1     Accessing the Sample Files and Dictionary

  4.2     Invoking and Exiting Interactive SQL

  4.3     Displaying Information About the Data

  4.4     Querying the Sample Data
    4.4.1      Querying Average Salaries by Sex
    4.4.2      Querying Gender Distinctions by Department
    4.4.3      Querying Employee Qualifications
    4.4.4      Querying Employees' Career Progression
    4.4.5      Querying Managerial Salaries

  5      Using CDD/Plus with RdbAccess for VAX RMS

  5.1     CDD/Plus Concepts

  5.2     Creating a CDD/Plus Dictionary

  5.3     Examining the Contents of a Dictionary

  5.4     Defining Dictionary Elements
    5.4.1      Defining Fields
    5.4.2      Defining Records
    5.4.3      Creating CDO Command Procedures
    5.4.4      Using a Command Procedure to Define Fields
    5.4.5      Using a Command Procedure to Define a Record
    5.4.6      Executing a Command Procedure
    5.4.7      Using the CDO Editor

  5.5     Deleting Dictionary Elements

  5.6     Protecting a CDD/Plus Dictionary
    5.6.1      Protecting a Data Definition

  6      Restrictions on RdbAccess for VAX RMS

  6.1     Restrictions on Using CDD/Plus
    6.1.1      Variant Records
    6.1.2      Datatype Support

  6.2     Restrictions on Using SQL
    6.2.1      Restrictions on Declaring Schemas
    6.2.2      Restrictions on Transactions
    6.2.3      Missing Values

  6.3     SQL Statements Not Supported by RdbAccess for VAX RMS

  7      Troubleshooting

  7.1     Types of Errors Commonly Encountered
    7.1.1      Getting More Information About Errors
    7.1.2      Execution Errors
      7.1.2.1      Avoiding Execution Errors
      7.1.2.2      Resolving Execution Errors
    7.1.3      Configuration Errors
    7.1.4      Resource Constraints
    7.1.5      Internal Errors

  7.2     Interpreting Error Messages
    7.2.1      Stacked Error Messages
    7.2.2      Error Message Format

  7.3     Error Message Documentation

  7.4     How to Submit a Software Performance Report (SPR)

  8      Performance Considerations

  8.1     Designing an Efficient Application

  8.2     Creating Efficient Data Definitions

  8.3     Tuning Your System

  9      DECLARE SCHEMA Qualifiers for RdbAccess for VAX RMS

  /DATA_DRIVER

  /DICTIONARY_DRIVER

  /PATHNAME

  /TYPE

  A   Error Messages

  Glossary

  EXAMPLES

  7-1        NSDS$DEBUG_FLAGS Display

  FIGURES

  1-1        RdbAccess for VAX RMS Components and Their Relationships

  1-2        RdbAccess for VAX RMS Software Configuration

  2-1        Relationship of the Schema to the Dictionary Hierarchy

  3-1        Emulating Relational Access to VSAM Data Sets

  TABLES

  1-1        Support for VAX RMS Record Formats

  2-1        Relationship of Database Terms

  2-2        Summary of Database Terms

  5-1        CDO SHOW Commands

  5-2        User-Specified Field Attributes

  5-3        User-Specified Record Attributes

  5-4        CDO Editor Key Functions

  5-5        DELETE Commands Qualifiers

  5-6        CDO Access Rights

  5-7        CDO Protection Commands

  6-1        Datatype Support

  6-2        RdbAccess for VAX RMS Datatype Translations

  7-1        Sources of Error Messages

  7-2        Error Message Severity Codes