CONTENTS

  Title Page

  Copyright Page

  Preface

  1      Accessing RMS Data Files

  1.1     How to Access RMS Data Files

  1.2     Determining Eligibility

  1.3     Creating Data Definitions

  1.4     Using SQL Statements in Programs

  1.5     Attaching to a Dictionary Directory

  1.6     Detaching from a Dictionary Directory

  1.7     Using Transactions
    1.7.1      Enabling RMS Journaling
    1.7.2      How the RMS Data Driver Handles Record Locking
    1.7.3      Support for the Two-Phase Commit Protocol

  1.8     Reading RMS Data Files

  1.9     Updating RMS Data Files
    1.9.1      Writing to an RMS Data File
    1.9.2      Updating RMS Data Files Without Recovery Unit Journaling

  1.10    Copying Records From One Database to Another

  2      Reading VSAM Data Sets

  2.1     Accessing VSAM Data Sets
    2.1.1      Defining a Logical Name for a VSAM Data Set
    2.1.2      Creating a Proxy Database

  2.2     Reading VSAM Data Sets

  2.3     Determining Eligibility of VSAM Data Sets

  2.4     Installing DTF

  2.5     Creating Data Definitions for the VSAM Data Set
    2.5.1      Using DEFINE RMS_DATABASE
    2.5.2      Using the DEFINE DATABASE Command with an Existing Data Set
    2.5.3      Specifying the Data Driver Image
    2.5.4      Specifying the Data Location

  2.6     Including SQL Statements in Programs

  2.7     Using Interactive SQL with VSAM Data Sets

  2.8     Securing DTF

  FIGURES

  1-1        The Relationship Between the Components of RdbAccess for VAX RMS

  1-2        How SQL Uses Markpoints

  2-1        Emulating Relational Access to VSAM Data Sets

  TABLES

  1-1        Operations Supported for Each File Type

  1-2        Support for RMS Record Formats

  1-3        How the RMS Data Driver Locks Records