OpenQM
Introduction to the QM Database
What is a Multivalue Database?
Installation
Startup and Shutdown of QM
Deinstallation
Accounts
Entering QM
The Login Process
Command Scripts
The Command Environment
The Command Stack
The Command Editor
Interrupting Commands
Output Pagination
The VOC File
VOC D-type records - Data items
VOC F-type records - File definitions
VOC K-type records - Keywords
VOC M-type records - Menu definitions
VOC PA-type records - Paragraphs
VOC PH-type records - Phrases
VOC PQ-type records - PROCs
VOC Q-type records - Remote file pointers
VOC R-type records - Remote pointers
VOC S-type records - Sentences
VOC V-type records - Verbs
VOC X-type records - Miscellaneous storage
Security subroutines
Inline Prompts
Pattern Matching
Printing
User Management and System Security
The QM File System
Creating and Deleting Files
Directory Files
Dynamic Files
QMNet Network File Access
The Virtual File System
Creating and Modifying Data
Dictionaries
Dictionary A and S-type records
Correlatives
A-Correlatives
F-Correlatives
Dictionary C-type records
Dictionary D-type records
Dictionary I-type records
Dictionary L-type records
Dictionary PH-type records
Dictionary X-type records
Associations
I-type expressions
Conversion Codes
A-correlative conversion (A)
Base 64 Conversion (B64)
Boolean conversion (B)
Concatenation conversion (C)
Date conversion (D)
F-correlative conversion (F)
Group conversion (G)
Integer conversion (IS, IL)
Length conversion (L)
Character conversion (MCx)
Masked decimal conversion (MD, ML, MR)
Time conversion (MT)
Radix conversion (MB, MO, MX)
Radix conversion (MCDX, MCXD)
Field extraction (<f,v,s>)
Pattern matching conversion (P)
Range check conversion (R)
Substitution conversion (S)
File translation conversion
Text substring conversion
User defined conversions
Format Specifications
Locks
Alternate Key Indices
Triggers
Data Encryption
Transactions
Select Lists
QM Commands
* (Comment)
$ECHO
ABORT
ACCOUNT.RESTORE
ACCOUNT.SAVE
ADMIN.USER
ALIAS
ANALYSE.FILE
AUTHENTICATE
AUTOLOGOUT
BASIC
BELL
BLOCK.PRINT and BLOCK.TERM
BREAK command
BUILD.INDEX
CATALOGUE
CLEAN.ACCOUNT
CLEAR.ABORT
CLEAR.DATA
CLEAR.FILE
CLEAR.INPUT
CLEAR.LOCKS
CLEAR.PROMPTS
CLEAR.SELECT
CLEAR.STACK
CLR
CNAME
COMO
COMPILE.DICT
CONFIG
CONFIGURE.FILE
COPY
COPYP
COPY.LIST
CREATE.ACCOUNT
CREATE.FILE
CREATE.INDEX
CREATE.KEY
CREATE.USER
CT
DATA
DATE
DATE.FORMAT
DEBUG
DELETE
DELETE.ACCOUNT
DELETE.CATALOGUE
DELETE.COMMON
DELETE.FILE
DELETE.INDEX
DELETE.KEY
DELETE.LIST
DELETE.USER
DISABLE.INDEX
DISPLAY
DUMP
ECHO
ED
EDIT.LIST
ENCRYPT.FILE
FILE.SAVE
FILE.STAT
FIND.ACCOUNT
FORMAT
FORM.LIST
FSTAT
GENERATE
GET.LIST
GET.STACK
GO
GRANT.KEY
HELP
HSM
HUSH
IF
INHIBIT.LOGIN
LIST.COMMON
LIST.DIFF
LIST.FILES
LIST.INDEX
LIST.INTER
LIST.KEYS
LIST.LOCKS
LIST.READU
LIST.UNION
LIST.USERS
LIST.VARS
LISTDICT
LISTF
LISTFL
LISTFR
LISTK
LISTM
LISTPA
LISTPH
LISTPQ
LISTQ
LISTR
LISTS
LISTU
LISTV
LOCK
LOGIN.PORT
LOGMSG
LOGOUT
LOGTO
LOOP / REPEAT
MAKE.INDEX
MAP
MED
MERGE.LIST
MESSAGE
MODIFY
NLS
NSELECT
OPTION
PASSWORD
PAUSE
PDEBUG
PDUMP
PHANTOM
PRINTER
PSTAT
PTERM
QSELECT
QUIT
RELEASE
REPORT.SRC
REPORT.STYLE
RESET.MASTER.KEY
RESTORE.ACCOUNTS
REVOKE.KEY
RUN
SAVE.LIST
SAVE.STACK
SCRB
SECURITY
SED
SED - Records, buffers and windows
SED - Standard key bindings
SED - Standard key bindings quick reference
SED - Cursor movement functions
SED - Data insertion
SED - Copying, deleting and restoring data
SED - Working with multivalued data
SED - Functions that operate of a block of data
SED - Changing text
SED - Macros
SED - File handling
SED - Repeating functions
SED - Miscellaneous functions
SED - Commands
SED - Setting up default modes
SED - Source control
SED - Dynamic key bindings
SED - Extension Programming
SED Extensions - Variables, constants and functions
SED Extensions - Standard variables and functions
SED Extensions - Argument Passing
SED Extensions - An example of a complex extension
SED Extensions - Local procedures and functions
SEL.RESTORE
SET
SET.DATE
SET.DEVICE
SET.ENCRYPTION.KEY.NAME
SET.EXIT.STATUS
SET.FILE
SET.QUEUE
SET.TRIGGER
SETPORT
SETPTR
SH
SLEEP
SP.ASSIGN
SP.OPEN, SP.CLOSE
SP.VIEW
SPOOL
STATUS
STOP
T.DUMP
T.LOAD
T.DET, T.EOD, T.FWD, T.RDLBL, T.READ, T.REW, T.STAT, T.WEOF
TERM
TIME
UMASK
UNLOCK
UNLOCK.KEY.VAULT
UPDATE.ACCOUNT
UPDATE.LICENCE
UPDATE.RECORD
UPDATE.RECORD batch mode
UPDATE.RECORD visual mode
WHO
WHERE
Query Processing
The Selection Clause
The Sort Clause
The Display Clause
SELECT and SSELECT
SEARCH
LIST and SORT
LIST.ITEM and SORT.ITEM
LIST.LABEL and SORT.LABEL
REFORMAT
COUNT
SUM
SHOW
Query processor keywords
ABSENT.IGNORE
ABSENT.NULL
ALL.MATCH
AND
AS
ASSOC
ASSOC.WITH
AVERAGE
BETWEEN
BOXED
BREAK.ON
BREAK.SUP
BY
BY.DSND
BY.EXP
BY.EXP.DSND
CALC
COL.HDG
COL.HDG.ID
COL.HDR.SUPP
COL.SPACES
CONV
COUNT.SUP
COL.SUP
CSV
CUMULATIVE
DBL.SPC
DELIMITER
DET.SUP
DISPLAY.LIKE
ENUMERATE
EQ
EVAL
FMT
FOOTING
FORCE
FROM
GE
GRAND.TOTAL
GT
HDR.SUP
HEADING
ID.ONLY
ID.SUP
IN
LABEL
LE
LIKE
LOCKING
LPTR
LT
MARGIN
MAX
MIN
MULTI.VALUE
NE
NEW.PAGE
NO
NO.CASE
NO.GRAND.TOTAL
NO.INDEX
NO.MATCH
NO.NULLS
NO.PAGE
NO.SPLIT