CONTENTS

  Title Page

  Copyright Page

  Preface

  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      Supported 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/AUDIT Commands
      9.4.1      DBO/AUDIT/ANALYZE Command
      9.4.2      DBO/AUDIT/LIST Command
      9.4.3      DBO/AUDIT/SET/OBJECT=COMMAND Command
      9.4.4      DBO/AUDIT/SET/OBJECT=DATABASE Command
      9.4.5      DBO/AUDIT/SET/OBJECT=SECURITY_SCHEMA Command
    9.5 DBO/BACKUP Commands
      9.5.1      DBO/BACKUP Database Command
      9.5.2      DBO/BACKUP/AFTER_JOURNAL Command
      9.5.3      DBO/BACKUP/MULTITHREAD Command
    9.6 DBO/CLOSE Command
    9.7 DBO/CONVERT Commands
      9.7.1      DBO/CONVERT Command
      9.7.2      DBO/CONVERT/CDD Command
    9.8 DBO/COPY_DATABASE Command
    9.9 DBO/CREATE Command
    9.10 DBO/DELETE Commands
      9.10.1     DBO/DELETE Root File Command
      9.10.2     DBO/DELETE/INSTANCE Command
      9.10.3     DBO/DELETE/SCHEMA Command
      9.10.4     DBO/DELETE/SECURITY_SCHEMA Command
      9.10.5     DBO/DELETE/STORAGE_SCHEMA Command
      9.10.6     DBO/DELETE/SUBSCHEMA Command
    9.11 DBO/DUMP Commands
      9.11.1     DBO/DUMP Database Command
      9.11.2     DBO/DUMP/AFTER_JOURNAL Command
      9.11.3     DBO/DUMP/BACKUP Command
      9.11.4     DBO/DUMP/BACKUP/MULTITHREAD Command
      9.11.5     DBO/DUMP/EXPORT Command
      9.11.6     DBO/DUMP/RECOVERY_JOURNAL Command
    9.12 DBO/EXPORT Command
    9.13 DBO/EXTRACT Command
    9.14 DBO/GRANT_COMMAND Commands
      9.14.1     DBO/GRANT_COMMAND/ADD Command
      9.14.2     DBO/GRANT_COMMAND/DELETE Command
      9.14.3     DBO/GRANT_COMMAND[/LIST] Command
    9.15 DBO/INITIALIZE Command
    9.16 DBO/INTEGRATE Command
    9.17 DBO/LOAD Commands
      9.17.1     DBO/LOAD Command
      9.17.2     DBO/LOAD/CONTINUE Command
    9.18 DBO/MODIFY Commands
      9.18.1     DBO/MODIFY Database Command
      9.18.2     DBO/MODIFY/RESTRUCTURE Command
    9.19 DBO/MONITOR Command
    9.20 DBO/MOVE_AREA Command
    9.21 DBO/OPEN Command
    9.22 DBO/OPTIMIZE Command
    9.23 DBO/PERMIT_USER Commands
      9.23.1     DBO/PERMIT_USER/ADD Command
      9.23.2     DBO/PERMIT_USER/DELETE Command
      9.23.3     DBO/PERMIT_USER[/LIST] Command
    9.24 DBO/RECOVER Command
    9.25 DBO/REPORT Command
    9.26 DBO/RESOLVE Command
    9.27 DBO/RESTORE Commands
      9.27.1     DBO/RESTORE Command
      9.27.2     DBO/RESTORE/MULTITHREAD Command
    9.28 DBO/SHOW Commands
      9.28.1     DBO/SHOW LICENSE Command
      9.28.2     DBO/SHOW LOCKS Command
      9.28.3     DBO/SHOW STATISTICS Command
      9.28.4     DBO/SHOW SYSTEM Command
      9.28.5     DBO/SHOW USERS Command
      9.28.6     DBO/SHOW VERSION Command
    9.29 DBO/UNLOAD Commands
      9.29.1     DBO/UNLOAD Command
      9.29.2     DBO/UNLOAD/CONTINUE Command
    9.30 DBO/VERIFY Command
    9.31 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