CONTENTS

  Title Page

  Copyright Page

  Send Us Your Comments

  Preface

  1      Summary of New and Changed Features
    1.1 New and Changed Features That Affect All Interfaces
    1.2 SQL New and Changed Features
    1.3 SQL/Services New Features
    1.4 RMU New and Changed Features
    1.5 SQL Multimedia New and Changed Features
    1.6 RDML New Features

  2      Using the New Features
    2.1 Memory Page Transfers
    2.2 Partitioned Lock Trees
    2.3 Fast Incremental Backup Operations
    2.4 Creating Several Storage Areas Asyncronously
    2.5 Dynamic OR Optimization
    2.6 Hashed Ordered Indexes Can Reference More Than One Column
    2.7 Using the OPTIMIZE Clause to Choose an Outline for a Query
    2.8 Logical Name Changes
    2.9 New Concatenation Optimizations for the Rdb Optimizer
    2.10 Integrating Domain and Table Definitions
      2.10.1     Integrating Domains
      2.10.2     Integrating Tables
    2.11 Authenticating Users
    2.12 RMUwin - Windowing Interface for RMU
      2.12.1     Features and Benefits of RMUwin
      2.12.2     Getting Started with RMUwin
    2.13 Using the RMU Windows Statistics Command
    2.14 Using the Input Control Mode of the RMU Show Statistics Utility
    2.15 Numeric Version of the RMU Show Statistics Transaction Durations Display
    2.16 RMU Show Statistics Reset Qualifier
    2.17 RMU Show Statistics Utility Now Displays Lock Information
    2.18 RMU Show Statistics Output Files Contain By-Area Information
    2.19 RMU Show Statistics Command Displays the CPU Utilization
    2.20 RMU Show Statistics Information Display Is Customizable
    2.21 Using the RMU Show Statistics Record Statistics Display to Identify Excessive I/O When Storing Records
    2.22 Using the RMU Show Statistics File IO Overview Display to Identify Excessive I/O in Storage Areas
    2.23 Analyzing Root File I/O Operations with RMU Show Statistics
    2.24 RMU Show Statistics IO Stall Time Display Provides Information on Stalls Caused by ALS Group Commit Operations
    2.25 RMU Show Statistics Displays I/O Information for the AIJ Cache on Electronic Disk
    2.26 RMU Show Statistics Command Has a Bell Option in the Stall Messages Screen
    2.27 RMU Show Statistics Command Supports a Notepad and Invoking DCL Commands
    2.28 RDML Qualifiers
      2.28.1     New /DATE_TYPE Qualifier for RDML/PASCAL
      2.28.2     New /QUADWORD Qualifier
      2.28.3     New /NEGSCALED_NUMERIC Qualifier

  3      SQL: New and Changed Features
    3.1 How to Read Syntax Diagrams
    3.2 LIKE Predicate Optimization in SQL Queries
    3.3 New Character Set Support in SQL
      3.3.1      Wildcard Characters Used with the LIKE Predicate
    3.4 Value Expressions
      3.4.1      Built-In Functions
        3.4.1.1      TRIM Function
        3.4.1.2      POSITION Function
    3.5 Select Expressions
    3.6 Change to System Relations Documentation
    3.7 SQL Module Language
      3.7.1      SQL Module Language Syntax
      3.7.2      SQL Module Language Processor Command Line
    3.8 SQL Precompiler
      3.8.1      SQL Precompiler Command Line
    3.9 New and Changed SQL Statements

  ALTER DATABASE Statement

  ATTACH Statement

  COMMENT ON Statement

  CONNECT Statement

  CREATE COLLATING SEQUENCE Statement

  CREATE DATABASE Statement

  CREATE DOMAIN Statement

  CREATE FUNCTION Statement

  CREATE MODULE Statement

  CREATE OUTLINE Statement

  DECLARE ALIAS Statement

  DELETE Statement

  DROP DATABASE Statement

  EXPORT Statement

  IMPORT Statement

  INTEGRATE Statement

  SELECT Statement
    SELECT Statement:  General Form
    SELECT Statement:  Singleton Select

  UNDECLARE Variable Statement

  UPDATE Statement
    3.10 SQL Routines

  sql_get_error_text

  sql_get_message_vector

  sql_signal

  A Summary of DEC Rdb Documentation
    A.1 Target Audience
    A.2 Documentation Descriptions
      A.2.1      General Interest to DEC Rdb Users
      A.2.2      Database Administration
      A.2.3      System Administration
      A.2.4      Database Development and Programming
      A.2.5      Client/Server Application Programming
      A.2.6      Release Notes
    A.3 Ordering DEC Rdb Documentation
      A.3.1      Documentation Available for DEC Rdb for DEC OSF/1 AXP
      A.3.2      Documentation Available for DEC Rdb on OpenVMS
      A.3.3      How to Order Additional Documentation

  Glossary
    client . . . server