CONTENTS

  Title Page

  Copyright Page

  Preface

  Technical Changes and New Features

  1      Introduction

  2      Schema Definition

  2.1     SCHEMA Entry

  2.2     Schema AREA Entry

  2.3     Schema RECORD Entry

  2.4     Schema SET Entry

  3      Storage Schema Definition

  3.1     STORAGE SCHEMA Entry

  3.2     Storage Schema RECORD Entry

  3.3     Storage Schema SET Entry

  4      Subschema Definition

  4.1     SUBSCHEMA Entry

  4.2     ALIAS Entry

  4.3     REALM Entry

  4.4     Subschema RECORD Entry

  4.5     Subschema SET Entry

  5      Security Schema Definition

  5.1     SECURITY SCHEMA Entry

  5.2     Security Schema AREA Entry

  5.3     Security Schema RECORD Entry

  5.4     Security Schema SET Entry

  6      DDL Compiler Commands

  6.1     DDL/COMPILE Command

  6.2     DDL/GENERATE Command

  6.3     DDL/MODIFY Command

  7      VAX Data Types

  7.1     INTEGER Data Types

  7.2     FLOATING POINT Data Types

  7.3     CHARACTER STRING Data Type

  7.4     DECIMAL STRING Data Types

  7.5     DATE Data Types
    7.5.1      Defining a DATE Data Item
    7.5.2      DATE Data Type Conversion
    7.5.3      Entering Date and Time as Character Strings
      7.5.3.1      Entering the Date Field
      7.5.3.2      Special DATE Input and Defaults
      7.5.3.3      Entering the Time Field
    7.5.4      DATE Output

  7.6     Errors, Equivalence, and Conversions

  8      Conditional Expressions

  8.1     Anatomy of a Conditional Expression
    8.1.1      Relational Expressions
    8.1.2      Combinations of Relational Expressions
    8.1.3      Examples of Condition Tests

  8.2     Evaluating Condition Tests
    8.2.1      Effects of Logical Operators
    8.2.2      Order of Evaluation

  9      DBO Utility Commands

  9.1     DBO Indirect-Command-File

  9.2     DBO/ALTER Command

  9.3     DBO/ANALYZE Command

  9.4     DBO/BACKUP Commands
    9.4.1      DBO/BACKUP Database Command
    9.4.2      DBO/BACKUP/AFTER_JOURNAL Command
    9.4.3      DBO/BACKUP/MULTITHREAD Command

  9.5     DBO/CLOSE Command

  9.6     DBO/CONVERT Command

  9.7     DBO/CREATE Command

  9.8     DBO/DELETE Commands
    9.8.1      DBO/DELETE Root File Command
    9.8.2      DBO/DELETE/INSTANCE Command
    9.8.3      DBO/DELETE/SCHEMA Command
    9.8.4      DBO/DELETE/SECURITY_SCHEMA Command
    9.8.5      DBO/DELETE/STORAGE_SCHEMA Command
    9.8.6      DBO/DELETE/SUBSCHEMA Command

  9.9     DBO/DUMP Commands
    9.9.1      DBO/DUMP Database Command
    9.9.2      DBO/DUMP/AFTER_JOURNAL Command
    9.9.3      DBO/DUMP/BACKUP Command
    9.9.4      DBO/DUMP/RECOVERY_JOURNAL Command

  9.10    DBO/EXTRACT Command

  9.11    DBO/GRANT_COMMAND Commands
    9.11.1     DBO/GRANT_COMMAND/ADD Command
    9.11.2     DBO/GRANT_COMMAND/DELETE Command
    9.11.3     DBO/GRANT_COMMAND[/LIST] Command

  9.12    DBO/INITIALIZE Command

  9.13    DBO/INTEGRATE Command

  9.14    DBO/LOAD Commands
    9.14.1     DBO/LOAD Command
    9.14.2     DBO/LOAD/CONTINUE Command

  9.15    DBO/MODIFY Commands
    9.15.1     DBO/MODIFY Database Command
    9.15.2     DBO/MODIFY/RESTRUCTURE Command

  9.16    DBO/MONITOR Command

  9.17    DBO/OPEN Command

  9.18    DBO/PERMIT_USER Commands
    9.18.1     DBO/PERMIT_USER/ADD Command
    9.18.2     DBO/PERMIT_USER/DELETE Command
    9.18.3     DBO/PERMIT_USER[/LIST] Command

  9.19    DBO/RECOVER Command

  9.20    DBO/REPORT Command

  9.21    DBO/RESTORE Commands
    9.21.1     DBO/RESTORE Command
    9.21.2     DBO/RESTORE/MULTITHREAD Command

  9.22    DBO/SHOW Commands
    9.22.1     DBO/SHOW GETLKI Command
    9.22.2     DBO/SHOW STATISTICS Command
    9.22.3     DBO/SHOW SYSTEM Command
    9.22.4     DBO/SHOW USERS Command
    9.22.5     DBO/SHOW VERSION Command

  9.23    DBO/UNLOAD Commands
    9.23.1     DBO/UNLOAD Command
    9.23.2     DBO/UNLOAD/CONTINUE Command

  9.24    DBO/VERIFY Command

  9.25    DBO/WORK_AREA Command

  10     Load/Unload Utility Commands

  10.1    Load/Unload Format Language
    10.1.1     RECORD Entry
    10.1.2     ITEM Entry
    10.1.3     SET Entry
    10.1.4     MEMBER Entry

  10.2    Load/Unload Sequence Language
    10.2.1     SEQUENCE Entry
    10.2.2     LOOP Entry
    10.2.3     Sequence Record Entry
      10.2.3.1     Load Sequence RECORD Entry
      10.2.3.2     Unload Sequence RECORD Entry

  11     DBALTER Utility Commands

  11.1    AREA...PAGE Command

  11.2    BIND Command

  11.3    COMMIT Command

  11.4    DEPOSIT Command

  11.5    DEPOSIT FILE Command

  11.6    DEPOSIT ROOT Command

  11.7    DISPLAY Command

  11.8    DISPLAY FILE Command

  11.9    DISPLAY ROOT Command

  11.10  EXIT Command

  11.11  HELP Command

  11.12  LOG Command

  11.13  MAKE_CONSISTENT Command

  11.14  MOVE Command

  11.15  NOLOG Command

  11.16  PAGE Command

  11.17  RADIX Command

  11.18  ROLLBACK Command

  11.19  UNBIND Command

  11.20  UNCORRUPT Command

  11.21  VERIFY Command

  12     DRU Commands

  12.1    ANALYZE Command

  12.2    BIND Command

  12.3    CLOSE Command

  12.4    CREATE Command

  12.5    DEFINE Command

  12.6    EDIT Command

  12.7    EXECUTE Command

  12.8    EXIT Command

  12.9    HELP Command

  12.10  MACRO Command

  12.11  OPEN Command

  12.12  RELEASE Command

  12.13  REMOVE Command

  12.14  SET Command

  12.15  SHOW Command

  12.16  UNBIND Command

  EXAMPLES

  7-1        Example for the DATE Text

  TABLES

  7-1        VAX Ada Data Types

  7-2        VAX BASIC Data Types

  7-3        VAX BLISS Data Types

  7-4        VAX COBOL Data Types

  7-5        VAX C Data Types

  7-6        VAX DIBOL Data Types

  7-7        VAX FORTRAN Data Types

  7-8        VAX MACRO Data Types

  7-9        VAX Pascal Data Types

  7-10       VAX PL/I Data Types

  8-1        Relational Operators

  8-2        Logical Operators

  8-3        Truth Table for Evaluating Conditions

  8-4        Truth Table Without Parentheses

  8-5        Truth Table with Parentheses

  9-1        DBO Command Qualifiers

  9-2        DBO Command Types