CONTENTS

  Title Page

  Copyright Page

  Preface

  1      Introduction

  2      DML Command, Statements, and Clauses
    2.1 DML Command
    2.2 DML Statements
      2.2.1      BIND Statement
      2.2.2      COMMIT Statement
      2.2.3      CONNECT Statement
      2.2.4      DISCONNECT Statement
      2.2.5      ERASE Statement
      2.2.6      FETCH Statements
        2.2.6.1      FETCH CURRENT Statement
        2.2.6.2      FETCH DBKEY Statement
        2.2.6.3      FETCH OWNER Statement
        2.2.6.4      FETCH Position-Expression Statement
        2.2.6.5      FETCH Position-Expression WITHIN Keeplist Statement
      2.2.7      FIND Statements
        2.2.7.1      FIND ALL Statement
        2.2.7.2      FIND CURRENT Statement
        2.2.7.3      FIND DBKEY Statement
        2.2.7.4      FIND OWNER Statement
        2.2.7.5      FIND Position-Expression Statement
        2.2.7.6      FIND Position-Expression WITHIN Keeplist Statement
      2.2.8      FREE Statements
        2.2.8.1      FREE ALL Statement
        2.2.8.2      FREE CURRENT Statement
        2.2.8.3      FREE Position-Expression WITHIN Keeplist Statement
      2.2.9      GET Statement
      2.2.10     IF Tests
        2.2.10.1     COMPARE Function
        2.2.10.2     COMPARE_STREAM Function
        2.2.10.3     EMPTY Function
        2.2.10.4     EMPTY_STREAM Function
        2.2.10.5     MEMBER Function
        2.2.10.6     MEMBER_STREAM Function
        2.2.10.7     OWNER Function
        2.2.10.8     OWNER_STREAM Function
        2.2.10.9     TENANT Function
        2.2.10.10    TENANT_STREAM Function
      2.2.11     INVOKE Statement
      2.2.12     KEEP Statements
        2.2.12.1     KEEP CURRENT Statement
        2.2.12.2     KEEP Position-Expression WITHIN Keeplist Statement
      2.2.13     MODIFY Statement
      2.2.14     PLACE Statement
      2.2.15     READY Statement
      2.2.16     RECONNECT Statement
      2.2.17     ROLLBACK Statement
      2.2.18     STORE Statement
      2.2.19     UNBIND Statement
    2.3 DML Clauses
      2.3.1      RETAINING Clause
      2.3.2      TRAP Clause
      2.3.3      WHERE Clause

  3      FDML Statements and Clauses
    3.1 FDML Statements
      3.1.1      COMMIT Statement
      3.1.2      CONNECT Statement
      3.1.3      DISCONNECT Statement
      3.1.4      ERASE Statement
      3.1.5      FETCH Statements
        3.1.5.1      FETCH CURRENT Statement
        3.1.5.2      FETCH DBKEY Statement
        3.1.5.3      FETCH KEEPLIST Statement
        3.1.5.4      FETCH OWNER Statement
        3.1.5.5      FETCH Positional Statement
      3.1.6      FIND Statements
        3.1.6.1      FIND ALL Statement
        3.1.6.2      FIND CURRENT Statement
        3.1.6.3      FIND DBKEY Statement
        3.1.6.4      FIND KEEPLIST Statement
        3.1.6.5      FIND OWNER Statement
        3.1.6.6      FIND Positional Statement
      3.1.7      FREE Statements
        3.1.7.1      FREE ALL Statement
        3.1.7.2      FREE CURRENT Statement
        3.1.7.3      FREE Keeplist Statement
      3.1.8      GET Statement
      3.1.9      IF Tests
        3.1.9.1      ALSO CURRENT Statement
        3.1.9.2      ALSO KEEPLIST Statement
        3.1.9.3      COMPARE Function
        3.1.9.4      COMPARE_STREAM Function
        3.1.9.5      EMPTY Function
        3.1.9.6      EMPTY_STREAM Function
        3.1.9.7      MEMBER Function
        3.1.9.8      MEMBER_STREAM Function
        3.1.9.9      NULL CURRENT Statement
        3.1.9.10     NULL KEEPLIST Statement
        3.1.9.11     OWNER Function
        3.1.9.12     OWNER_STREAM Function
        3.1.9.13     TENANT Function
        3.1.9.14     TENANT_STREAM Function
        3.1.9.15     WITHIN CURRENT Statement
        3.1.9.16     WITHIN KEEPLIST Statement
      3.1.10     INVOKE Statement
      3.1.11     KEEP Statements
        3.1.11.1     KEEP CURRENT Statement
        3.1.11.2     KEEP KEEPLIST Statement
      3.1.12     MODIFY Statement
      3.1.13     READY Statement
      3.1.14     RECONNECT Statement
      3.1.15     ROLLBACK Statement
      3.1.16     STORE Statement
      3.1.17     USE Statement
    3.2 FDML Clauses
      3.2.1      END Clause
      3.2.2      ERR Clause
      3.2.3      RETAINING Clause
      3.2.4      WHERE Clause
    3.3 Current Status Registers
      3.3.1      Database Condition Register
      3.3.2      Current of Run-Unit Name Register
      3.3.3      Current of Run-Unit Name Size Register
      3.3.4      Current of Run-Unit ID Register

  4      Interactive DBQ Commands
    4.1 ACCEPT Command
    4.2 BIND Command
    4.3 DISPLAY Command
    4.4 EDIT Command
    4.5 EXIT Command
    4.6 HARDCOPY Command
    4.7 HELP Command
    4.8 IF Commands
      4.8.1      IF ALSO Command
      4.8.2      IF EMPTY Command
      4.8.3      IF MEMBER Command
      4.8.4      IF NULL Command
      4.8.5      IF OWNER Command
      4.8.6      IF TENANT Command
      4.8.7      IF WITHIN Command
    4.9 INITIALIZE Command
    4.10 LOOP Command
    4.11 MACRO Command
    4.12 MOVE Command
    4.13 PRINT Command
    4.14 SET Command
    4.15 SHIFT Command
    4.16 SHOW Command
    4.17 UNBIND Command

  5      DBCS Functions
    5.1 DBM$ACCEPT Function
    5.2 DBM$ACCEPT_STREAM Function
    5.3 DBM$GET_DBKEY Function
    5.4 DBM$GET_DBKEY_STREAM Function
    5.5 DBM$KPL_COUNT Function
    5.6 DBM$KPL_COUNT_STREAM Function
    5.7 DBM$PLACE Function
    5.8 DBM$PLACE_STREAM Function
    5.9 DBM$SIGNAL Function
    5.10 DBM$SIGNAL_STREAM Function
    5.11 DBM$STATS Function
    5.12 DBM$STATS_STREAM Function

  6      Callable DBQ Routines
    6.1 User Work Areas
    6.2 Callable DBQ Routines
      6.2.1      DBQ$COMPILE Routine
      6.2.2      DBQ$COMPILE_STREAM Routine
      6.2.3      DBQ$EXECUTE Routine
      6.2.4      DBQ$EXECUTE_STREAM Routine
      6.2.5      DBQ$INTERPRET Routine
        6.2.5.1      Ada
        6.2.5.2      BASIC
        6.2.5.3      BLISS
        6.2.5.4      C
        6.2.5.5      DIBOL
        6.2.5.6      MACRO-32
        6.2.5.7      Pascal
        6.2.5.8      PL/I
      6.2.6      DBQ$INTERPRET_STREAM Routine
      6.2.7      DBQ$RELEASE Routine
      6.2.8      DBQ$RELEASE_STREAM Routine

  7      System and Process Logical Names
    7.1 DBM$BIND_ABW_DISABLED Logical
    7.2 DBM$BIND_APF_DEPTH Logical
    7.3 DBM$BIND_APF_DISABLED Logical
    7.4 DBM$BIND_BATCH_MAX Logical
    7.5 DBM$BIND_BUFFERS Logical
    7.6 DBM$BIND_CKPT_TRANS_INTERVAL Logical
    7.7 DBM$BIND_CLEAN_BUF_CNT Logical
    7.8 DBM$BIND_HOLD_RETRIEVAL_LOCKS Logical
    7.9 DBM$BIND_LOCK_TIMEOUT_INTERVAL Logical
    7.10 DBM$BIND_READY_AREA_SERIALLY Logical
    7.11 DBM$BIND_RUJ_EXTEND_BLKCNT Logical
    7.12 DBM$BIND_STACK_SIZE Logical
    7.13 DBM$BIND_TRANSFER_PARAMETERS Logical
    7.14 DBM$BIND_VM_SEGMENT Logical
    7.15 DBM$BIND_WAIT_RECORD_LOCKS Logical
    7.16 DBM$BUGCHECK_DIR Logical
    7.17 DBM$DML_INVOKE_ROOT Logical
    7.18 DBM$RUJ Logical
    7.19 DBM$SORT_FILES Logical
    7.20 DBM$MON_USERNAME Logical
    7.21 DBQ$EDIT Logical
    7.22 DRUINI Logical
    7.23 System Logicals Used by DEC DBMS