CONTENTS

  Title Page

  Copyright Page

  Preface

  1      Rdb/VMS Overview

  1.1     Understanding Rdb/VMS Concepts, Features, and Terminology
    1.1.1      Understanding Relational Concepts as Implemented in Rdb/VMS
    1.1.2      Understanding Rdb/VMS Features
    1.1.3      Understanding Differences in Relational Terminology

  1.2     Accessing Online Help for Rdb/VMS

  1.3     Setting Up the Sample Database

  1.4     Accessing Rdb/VMS Using SQL
    1.4.1      Using Interactive SQL
      1.4.1.1      Accessing Interactive SQL
      1.4.1.2      Retrieving Data Using SQL SELECT Statements
      1.4.1.3      Using Indexes for Retrieving Data
      1.4.1.4      Joining Data from Multiple Tables
      1.4.1.5      Isolating Unique Data Values
    1.4.2      Using SQL Statements in Programs
      1.4.2.1      Using SQL Module Language
      1.4.2.2      Using Precompiled SQL
      1.4.2.3      Using Dynamic SQL
      1.4.2.4      Using the SQL Online Program Examples
    1.4.3      Accessing Rdb/VMS from Systems Other Than VMS Using SQL/Services

  1.5     Accessing Rdb/VMS Using RDO, RDML, and RDBPRE
    1.5.1      Introducing RDO, RDML, RDBPRE, and Other Interfaces
    1.5.2      Using the Online Program Examples for RDO, RDML, and RDBPRE

  1.6     Maintaining and Tuning Rdb/VMS Databases with RMU

  1.7     Rdb/VMS Product Kits

  1.8     Using Rdb/VMS with Other Digital Products

  2      Rdb/VMS Documentation Directory

  Glossary
    access control entry (ACE) . . . aggregate expression
    AIJ . . . Application Programming Interface (API)
    APS . . . attachment
    attribute . . . binary language representation (BLR)
    bind . . . call interface
    call parameter . . . client
    clump . . . commit phase
    common data dictionary . . . consistency
    constant . . . cross product
    cursor . . . data compression
    data definition language (DDL) . . . DBR
    DCL . . . default value
    deferred snapshots . . . DISTINCT clause
    distributed transaction . . . embedded DML
    embedded RDO . . . extent
    extraction . . . function
    generic execution server . . . host language variable
    host structure . . . indicator vector
    initializing phase . . . join
    journal file . . . literal
    LMF . . . message file
    message protocol . . . multisegmented index
    multithreaded . . . optimizer
    outer query . . . PLACEMENT VIA index option
    plan file . . . primary key
    print list . . . query optimizer
    query specification . . . RDMS$BIND_SEGMENTED_STRING_BUFFER
    RDMS$BIND_SORT_WORKFILES . . . record stream
    recovery . . . relational operator
    relative path name . . . RMU
    roll back . . . schema
    schema element . . . security manager
    security operator terminal . . . shadowing
    share mode . . . spooling
    SQL$DATABASE . . . SQL precompiler
    SQL/Services . . . subselect
    substring . . . threshold
    TID . . . tuple
    two-phase commit protocol . . . VAXcluster
    vector . . . working phase

  A   Rdb/VMS Master Index

  TABLES

  1-1        Sample COLLEGES Table

  1-2        CURRENT_SALARY View

  1-3        Differences in Relational Terminology

  1-4        Syntax Differences Between SQL and RDO

  1-5        SQL Files to Create Sample Databases

  1-6        Program File Types

  1-7        Online Program Examples for RDBPRE and RDML

  A-1        Abbreviations for the Manuals Included in the Master Index