CONTENTS Title Page Copyright Page Send Us Your Comments Preface 1 Overview of DEC DB Integrator Gateway for DBMS 2 Accessing DEC DBMS Data 2.1 Attaching to a Database 2.2 Mapping DEC DBMS Data to the Relational Format 2.2.1 Mapping Sets and Records to Tables 2.2.2 Mapping Data Items 2.3 Using Transactions 2.4 Using SQL Statements to Access a DEC DBMS Database 2.4.1 Reading Data 2.4.2 Modifying Data 2.4.3 Using the JOIN_KEY Field 2.5 Optimizing Performance 2.5.1 Reducing Attach Time 2.5.2 Defining Table Cardinality 2.5.3 Using Indexes 3 Tutorial Session Using the DEC DBMS Sample Database 3.1 Creating the Sample Database 3.2 Accessing the Sample Database 3.3 Mapping Sets and Records to Tables 3.4 Displaying Sets, Records, and Tables 3.5 Reading the Sample Data 3.6 Updating the Sample Data