CONTENTS

  Title Page

  Copyright Page

  Preface

  Important Notice for Readers

  Structure and Content of This Manual

  Technical Changes and New Features

  1      RDO Language Elements

  1.1     The RDO Session
    1.1.1      Beginning an RDO Session
    1.1.2      Getting Information in RDO
    1.1.3      Exiting from RDO

  1.2     Prompts

  1.3     Statements
    1.3.1      Keywords
      1.3.1.1      Required Keywords
      1.3.1.2      Optional Keywords
    1.3.2      User-Supplied Names
    1.3.3      Literal Values
    1.3.4      Expressions
    1.3.5      Data Dictionary Path Names
    1.3.6      File Specifications
    1.3.7      Terminating Statements

  2      Overview of Rdb/VMS Functions

  2.1     Data Definition Statements

  2.2     Data Manipulation Statements

  2.3     Database Maintenance and Performance Statements

  2.4     Statements for Interactive Control

  2.5     VAX Data Distributor Statements

  3      Value Expressions and Conditional Expressions

  3.1     Value Expressions
    3.1.1      Host Language Variables
    3.1.2      Literals
      3.1.2.1      Character String Literals
      3.1.2.2      Numeric Literals
      3.1.2.3      Date Literals
    3.1.3      Statistical Expressions
      3.1.3.1      The TOTAL Statistical Function
      3.1.3.2      The COUNT Statistical Function
      3.1.3.3      The AVERAGE Statistical Function
      3.1.3.4      The MAX Statistical Function
      3.1.3.5      Global Aggregates
    3.1.4      Arithmetic Expressions
    3.1.5      Concatenated Expressions
    3.1.6      Missing Values (RDB$MISSING Expression)
    3.1.7      FIRST FROM Expression
    3.1.8      Database Key
    3.1.9      Segmented String Expressions

  3.2     Conditional Expressions
    3.2.1      Relational Operators
    3.2.2      Logical Operators

  4      The Record Selection Expression (RSE)

  4.1     Format of the Record Selection Expression

  4.2     The FIRST Clause:  Restricting the Number of Records

  4.3     The Relation Clause:  Context Variables in Streams and Loops

  4.4     The WITH Clause:  Specifying Conditions for the Record Stream

  4.5     The SORTED BY Clause:  Sorting Records

  4.6     The REDUCED TO Clause:  Retaining Only Unique Field Values

  4.7     The CROSS Clause:  Joining Related Records

  4.8     Views and the Record Selection Expression

  5      Field Attributes in Relations and Views

  5.1     Data Type Clause

  5.2     Validity Clause

  5.3     Missing Value Clause

  5.4     DATATRIEVE Support Clauses

  5.5     Collating Sequence Clause

  6      VAX Rdb/VMS Statements

  6.1     ANALYZE Statement

  6.2     CHANGE DATABASE Statement

  6.3     CHANGE FIELD Statement

  6.4     CHANGE INDEX Statement

  6.5     CHANGE PROTECTION Statement

  6.6     CHANGE RELATION Statement

  6.7     CHANGE STORAGE MAP Statement

  6.8     COMMIT Statement

  6.9     CREATE_SEGMENTED_STRING Statement

  6.10    DCL Invoke ( $ ) Statement

  6.11    DECLARE_STREAM Statement

  6.12    DEFINE COLLATING_SEQUENCE Statement

  6.13    DEFINE CONSTRAINT Statement

  6.14    DEFINE DATABASE Statement

  6.15    DEFINE FIELD Statement

  6.16    DEFINE INDEX Statement

  6.17    DEFINE PROTECTION Statement

  6.18    DEFINE RELATION Statement

  6.19    DEFINE SCHEDULE Statement (VAX Data Distributor)

  6.20    DEFINE STORAGE MAP Statement

  6.21    DEFINE TRANSFER Statement (VAX Data Distributor)

  6.22    DEFINE TRIGGER Statement

  6.23    DEFINE VIEW Statement

  6.24    DELETE COLLATING_SEQUENCE Statement

  6.25    DELETE CONSTRAINT Statement

  6.26    DELETE DATABASE Statement

  6.27    DELETE FIELD Statement

  6.28    DELETE INDEX Statement

  6.29    DELETE PATHNAME Statement

  6.30    DELETE PROTECTION Statement

  6.31    DELETE RELATION Statement

  6.32    DELETE SCHEDULE Statement (VAX Data Distributor)

  6.33    DELETE STORAGE MAP Statement

  6.34    DELETE TRANSFER Statement (VAX Data Distributor)

  6.35    DELETE TRIGGER Statement

  6.36    DELETE VIEW Statement

  6.37    EDIT Statement

  6.38    END_SEGMENTED_STRING Statement

  6.39    END_STREAM Statement

  6.40    ERASE Statement

  6.41    Execute ( @ ) Statement

  6.42    EXIT Statement

  6.43    EXPORT Statement

  6.44    FETCH Statement

  6.45    FINISH Statement

  6.46    FOR Statement

  6.47    FOR Statement with Segmented Strings

  6.48    GET Statement

  6.49    HELP Statement

  6.50    IMPORT Statement

  6.51    INTEGRATE DATABASE Statement

  6.52    INVOKE DATABASE Statement

  6.53    MODIFY Statement

  6.54    ON ERROR Clause

  6.55    PLACE Statement

  6.56    PRINT Statement

  6.57    READY Statement

  6.58    REINITIALIZE TRANSFER Statement (VAX Data Distributor)

  6.59    ROLLBACK Statement

  6.60    SET Statement

  6.61    SHOW Statements
    6.61.1     SHOW ALL Statement
    6.61.2     SHOW COLLATING_SEQUENCE Statement
    6.61.3     SHOW CONSTRAINTS Statement
    6.61.4     SHOW DATABASES Statement
    6.61.5     SHOW DATE_FORMAT Statement
    6.61.6     SHOW DICTIONARY Statement
    6.61.7     SHOW FIELDS Statement
    6.61.8     SHOW INDEXES Statement
    6.61.9     SHOW LANGUAGE Statement
    6.61.10    SHOW PRIVILEGES Statement
    6.61.11    SHOW PROTECTION Statement
    6.61.12    SHOW RADIX_POINT Statement
    6.61.13    SHOW RELATIONS Statement
    6.61.14    SHOW STORAGE AREAS Statement
    6.61.15    SHOW STORAGE MAPS Statement
    6.61.16    SHOW STREAMS Statement
    6.61.17    SHOW TRANSACTION Statement
    6.61.18    SHOW TRANSFER Statement (VAX Data Distributor)
    6.61.19    SHOW TRIGGERS Statement
    6.61.20    SHOW VERSIONS Statement

  6.62    START_SEGMENTED_STRING Statement

  6.63    START_STREAM Statement, Declared

  6.64    START_STREAM Statement, Undeclared

  6.65    START_TRANSACTION Statement

  6.66    START TRANSFER Statement (VAX Data Distributor)

  6.67    STOP TRANSFER Statement (VAX Data Distributor)

  6.68    STORE Statement

  6.69    STORE Statement with Segmented Strings

  A   Rdb/VMS Reserved Words

  B   Rdb/VMS Error Message Explanation Files

  C   Components of Run-Time Only License

  D   RDO Statements Not Supported in Rdb/VMS Versions 3.1 and 4.0

  D.1     BACKUP Statement

  D.2     CLOSE Statement

  D.3     CONVERT Statement

  D.4     OPEN Statement

  D.5     RECOVER Statement

  D.6     REFRESH MONITOR LOG Statement

  D.7     RESTORE Statement

  D.8     SHOW MONITOR Statement

  D.9     SHOW USERS Statement

  D.10    SPOOL Statement

  D.11    STOP MONITOR Statement

  FIGURES

  1 A Sample Syntax Diagram

  1-1        DEFINE CONSTRAINT-a Sample Syntax Diagram

  3-1        Using a Statistical Expression to Group Records

  3-2        A Statistical Expression Across Three Relations

  5-1        A Record with a Segmented String Field

  TABLES

  2-1        Rdb/VMS Data Definition Statements

  2-2        Rdb/VMS Data Manipulation Statements

  2-3        Rdb/VMS Database Maintenance and Performance Statements

  2-4        RDO Statements for Interactive Control

  2-5        VAX Data Distributor Statements

  3-1        Quotation Marks in Character String Literals

  3-2        Rdb/VMS Statistical Operators

  3-3        RDO Relational Operators

  3-4        Rdb/VMS Logical Operators-the AND Operator

  3-5        Rdb/VMS Logical Operators-the OR Operator

  3-6        Rdb/VMS Logical Operators-the NOT Operator

  5-1        Rdb/VMS Data Types

  6-1        CHANGE RELATION Options and Privileges

  6-2        Defaults for DEFINE DATABASE Statement

  6-3        Data Manipulation Access Rights

  6-4        DDL and Administrative Statements Controlled by Database ACL

  6-5        DDL and Administrative Statements Controlled by ACL for Each Relation, Local Field, or View in Statement

  6-6        Task-Oriented Summary of Required Privileges

  6-7        Privilege Override Capability

  6-8        Record Data Updates

  6-9        Logical Names for Internationalization of SET Statements

  6-10       Rdb/VMS SHOW Statements

  6-11       Defaults for the START_TRANSACTION Statement

  6-12       VAX Rdb/VMS Share Modes

  6-13       Comparison of Share Modes for Updates

  C-1        RDO Statements Available in RTO License