OpenQM

OpenQM
Introduction to the QM Database
The Command Environment
The QM File System
QM Commands
Query Processing
- The Selection Clause
- The Sort Clause
- The Display Clause
- SCAN
- SELECT and SSELECT
- SEARCH
- LIST and SORT
- LIST.ITEM and SORT.ITEM
- LIST.LABEL and SORT.LABEL
- REFORMAT and SREFORMAT
- 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.SPACE
- COL.HDR.SUPP
- COL.SPACES
- CONV
- COUNT.SUP
- COL.SUP
- CSV
- CUMULATIVE
- DBL.SPC
- DEFAULT
- DELIMITER
- DET.SUP
- DISPLAY.LIKE
- ELEMENT
- ENUMERATE
- EQ
- EVAL
- FMT
- FOOTING
- FOR
- FORCE
- FROM
- GE
- GRAND.TOTAL
- GT
- HDR.SUP
- HEADING
- ID.ONLY
- ID.SUP
- IN
- LABEL
- LE
- LIKE
- LOCKING
- LPTR
- LT
- MARGIN
- MAX
- MEDIAN
- MIN
- MODE
- MULTI.VALUE
- NE
- NEW.PAGE
- NO
- NOT
- NO.CASE
- NO.GRAND.TOTAL
- NO.INDEX
- NO.MATCH
- NO.NULLS
- NO.PAGE
- NO.SPLIT
- NOT.IN
- OR
- OVERLAY
- PAGESEQ
- PAN
- PERCENTAGE
- RANGE
- REQUIRE.INDEX
- REQUIRE.SELECT
- REPEATING
- REPORTING
- RPT
- SAID
- SAMPLE
- SAMPLED
- SAVING { UNIQUE}
- SCROLL
- SINGLE.VALUE
- SORT.SUP
- SORTED.SAMPLE
- STRINGS
- STYLE
- TO (Selection verbs)
- TO (REFORMAT)
- TOTAL
- UNLIKE
- USING
- VERTICALLY
- WHEN
- WITH
- WITHOUT
- XML
QMBasic
- QMBasic overview
- QMBasic - Compiler Directives
- QMBasic Limits
- QMBasic Statements and Functions by Type
- QMBasic Statements and Functions by Name
  - @(x,y) Function
  - ABORT
  - ABS()
  - ACCEPT.SOCKET.CONNECTION()
  - ACCOUNT.PATH()
  - ACOS()
  - ALPHA()
  - ANDS()
  - ARG()
  - ARG.COUNT()
  - ARG.PRESENT()
  - ASCII()
  - ASIN()
  - ASSIGNED()
  - ATAN()
  - BEGIN CASE
  - BEGIN TRANSACTION
  - BINDKEY()
  - BITAND()
  - BITNOT()
  - BITOR()
  - BITRESET()
  - BITSET()
  - BITTEST()
  - BITXOR()
  - BOOL()
  - BREAK
  - BREAK.COUNT()
  - BSCAN
  - CALL, ENTER
  - CASING
  - CATALOGUED()
  - CATS()
  - CAUGHT()
  - CEIL(), FLOOR()
  - CHAIN
  - CHANGE()
  - CHAR()
  - CHECKSUM()
  - CHILD()
  - CLASS
  - CLEAR
  - CLEARCOMMON
  - CLEARDATA
  - CLEARFILE
  - CLEARINPUT
  - CLEARSELECT
  - CLOSE
  - CLOSE.SOCKET
  - CLOSESEQ
  - COL1()
  - COL2()
  - COLLECTION()
  - COMMON
  - COMPARE(), COMPARES()
  - CONFIG()
  - CONNECT.PORT()
  - CONTINUE
  - CONVERT
  - COS()
  - COUNT()
  - CREATE
  - CREATE.FILE
  - CREATE.SERVER.SOCKET
  - CROP()
  - CSVDQ()
  - CSV.MODE
  - DATA
  - DATE()
  - DCOUNT()
  - DEBUG
  - DECRYPT()
  - DEFFUN
  - DEL
  - DELETE
  - DELETELIST
  - DELETESEQ
  - DFPART()
  - DIGEST()
  - DIMENSION
  - DIR()
  - DISINHERIT
  - DISPLAY
  - DISPLAY.WIDTH
  - DISABLE.KEY
  - DIV()
  - DOWNCASE()
  - DPARSE and DPARSE.CSV
  - DTX()
  - EBCDIC()
  - ECHAR()
  - ECHO
  - ELEMENT.EXISTS()
  - ENABLE.KEY
  - ENCRYPT(), ENCRYPTX()
  - END
  - ENTER.PACKAGE()
  - ENUMERATE()
  - ENV()
  - EPOCH()
  - EQS()
  - EQUATE
  - EREPLACE()
  - ERRMSG
  - EVALUATE
  - EXECUTE
  - EXIT
  - EXIT.PACKAGE()
  - EXP()
  - EXPAND()
  - EXTRACT()
  - FCONTROL()
  - FIELD()
  - FIELDSTORE()
  - FILE
  - FILE.EVENT
  - FILEINFO()
  - FILELOCK
  - FILEUNLOCK
  - FIND
  - FINDSTR
  - FIX()
  - FLUSH
  - FLUSH.DH.CACHE
  - FMT()
  - FMTDW(), FMTDWS()
  - FOLD() and FOLDS()
  - FOLDDW(), FOLDDWS()
  - FOOTING
  - FOR / NEXT
  - FORMCSV()
  - FORMLIST, FORMLISTV
  - FUNCTION
  - GES()
  - GET
  - GET(ARG.)
  - GET.MESSAGES()
  - GET.PORT.PARAMS()
  - GETLIST, GETLISTV
  - GETLOCKS()
  - GETNLS()
  - GETPU()
  - GETREM()
  - GOSUB
  - GOTO
  - GROUPSTORE
  - GTS()
  - HEADING
  - HUSH
  - ICONV()
  - IDIV()
  - IF /THEN / ELSE
  - IFS()
  - IN
  - INDEX()
  - INDICES()
  - INHERIT
  - INMAT()
  - INPUT, INPUTDW
  - INPUT @
  - INPUTCSV
  - INPUTFIELD
  - INPUTIF
  - INPUTNULL
  - INPUTTRAP
  - INS
  - INT()
  - INVERT()
  - IS.ALNUM(), IS.ALPHA(), IS.DIGIT(), IS.GRAPH(), IS.MARK(), IS.SPACE(), IS.WIDE()
  - IS.ECS()
  - IS.NULL()
  - IS.WIDESTR()
  - ITYPE()
  - JBUILD()
  - JPARSE()
  - KEEP.SELECT
  - KEY
  - KEYCODE()
  - KEYEDIT
  - KEYEXIT
  - KEYIN()
  - KEYINV()
  - KEYREADY()
  - KEYTRAP
  - LAST()
  - LEFT()
  - LEN()
  - LES()
  - LISTINDEX()
  - LN()
  - LOCAL
  - LOCATE
  - LOCK
  - LOGMSG
  - LOOP / REPEAT
  - LOWER()
  - LTS()
  - MARK.MAPPING
  - MAT
  - MAT()
  - MATBUILD
  - MATCHESS()
  - MATCHFIELD(), MATCHFIELDS()
  - MATPARSE
  - MATREAD, MATREADL, MATREADU
  - MATREADCSV
  - MATSTR()
  - MATWRITE
  - MATWRITECSV
  - MAX()
  - MAXIMUM()
  - MD5()
  - MERGELIST()
  - MIN()
  - MINIMUM()
  - MOD()
  - MOUSE
  - MOVELIST
  - MVDATE()
  - MVDATE.TIME()
  - MVEPOCH()
  - MVTIME()
  - NAP
  - NEG()
  - NES()
  - NOBUF
  - NOT()
  - NULL
  - NUM()
  - NUMERIC()
  - NV(), NS()
  - OBJECT()
  - OBJINFO()
  - OCONV()
  - ON GOSUB
  - ON GOTO
  - OPEN
  - OPENPATH
  - OPENSEQ
  - OPENTEMP
  - OPEN.SOCKET()
  - OPTION()
  - ORS()
  - OS.ERROR()
  - OS.EXECUTE
  - OSDELETE
  - OSPATH()
  - OSREAD
  - OSRENAME()
  - OSWRITE
  - OUTERJOIN()
  - PAGE
  - PARSE()
  - PAUSE
  - PDUMP
  - PHANTOM
  - POOL.IDLE
  - PRECISION
  - PRINT
  - PRINTCSV
  - PRINTER
  - PRINTER CLOSE
  - PRINTER DISPLAY
  - PRINTER FILE
  - PRINTER NAME
  - PRINTER RESET
  - PRINTER SETTING
  - PRINTER.SETTING()
  - PRINTERR
  - PRIVATE
  - PROCREAD
  - PROCWRITE
  - PROGRAM
  - PROMPT
  - PTERM()
  - PUBLIC
  - PWR()
  - QUOTE()
  - RAISE()
  - RANDOMIZE
  - RDIV()
  - READ
  - READ.SOCKET()
  - READBLK
  - READCSV
  - READL
  - READLIST
  - READNEXT
  - READSEQ
  - READU
  - READV
  - READVL, READVU
  - RECORDLOCKED()
  - RECORDLOCKL, RECORDLOCKU
  - REGEX()
  - RELEASE
  - REM()
  - REMARK
  - REMOVE, REMOVE(), REVREMOVE
  - REMOVE.BREAK.HANDLER
  - REMOVEF()
  - REPLACE()
  - RESTORE.SCREEN
  - RESTRICTED
  - RETURN
  - REUSE()
  - REUSING()
  - RIGHT()
  - RMVD()
  - ROOT
  - RND()
  - ROUNDDOWN(), ROUNDUP()
  - SADD(), SDIV(), SMUL(), SSUB()
  - SAVE.SCREEN()
  - SAVELIST
  - SCAN
  - SCMP()
  - SEEK
  - SELECT, SELECTN, SELECTV
  - SELECT.SOCKET()
  - SELECTE
  - SELECTINDEX, SELECTINDEXV
  - SELECTINFO()
  - SELECTLEFT, SELECTRIGHT
  - SEND
  - SENTENCE()
  - SEQ()
  - SERVER.ADDR()
  - SERVER.WINDOW()
  - SET.ARG
  - SET.BREAK.HANDLER
  - SET.ECS.MAP()
  - SET.EXIT.STATUS
  - SETLEFT, SETRIGHT
  - SET.PORT.PARAMS()
  - SET.SOCKET.MODE()
  - SET.STATUS
  - SET.TIMEZONE
  - SETNLS
  - SETPU
  - SETREM
  - SHARED
  - SHIFT()
  - SIGNAL()
  - SIN()
  - SLEEP
  - SOCKET.INFO()
  - SORT()
  - SORTADD
  - SORTCLEAR
  - SORTDATA()
  - SORTNEXT()
  - SORT.COMPARE()
  - SOUNDEX()
  - SPACE()
  - SQRT()
  - SPLICE()
  - SQUOTE()
  - SSELECT, SSELECTN, SSELECTV
  - STATUS()
  - STATUS
  - STOP
  - STR()
  - SUBR()
  - SUBROUTINE
  - SUBSTITUTE()
  - SUBSTRDW(), SUBSTRDWS()
  - SUBSTRINGS()
  - SUM()
  - SUMMATION()
  - SWAPCASE()
  - SWAPMARKS()
  - SYSMSG()
  - SYSTEM()
  - TAN()
  - TCLREAD
  - TERMINFO(), TERMINFO.EX()
  - TESTLOCK()
  - THROW
  - TIME()
  - TIMEDATE()
  - TIMEOUT
  - TOTAL()
  - TRANS(), RTRANS(), XLATE()
  - TRANSACTION ABORT, TRANSACTION COMMIT, TRANSACTION START
  - TRANSLITERATE()
  - TRIM()
  - TRIMB()
  - TRIMF()
  - TRIMS()
  - TRIMW(), TRIMWS()
  - TRY / CATCH
  - TTYGET()
  - TTYSET
  - UNASSIGNED()
  - UNLOCK
  - UNTIL
  - UPCASE()
  - VALIDATE()
  - VARTYPE()
  - VOCPATH()
  - VOID
  - VSLICE()
  - WAIT.FILE.EVENT
  - WAKE
  - WEOFSEQ
  - WHILE
  - WRITE
  - WRITE.SOCKET()
  - WRITEBLK
  - WRITECSV
  - WRITELIST
  - WRITESEQ
  - WRITEV
  - XTD()
- Character Values for Terminal Input
- @-Variables
- Standard Subroutines and Classes
  - !ABSPATH()
  - !ACCOUNT.RULES
  - !ATVAR()
  - !CALLHTTP
  - !CED()
  - !CHMOD
  - !DUMP()
  - !ERRTEXT()
  - !EXC.STACK()
  - !FINDPROG()
  - !GETPU()
  - !LISTU()
  - !MULTISORT
  - !OSCOPY
  - !PACKAGE()
  - !PARSER()
  - !PATHTKN()
  - !PCL()
  - !PHLOG()
  - !PICK()
  - !PICKLIST()
  - !PSTAT()
  - !QMCLIENT
  - !SCREEN()
  - !SETPU()
  - !SETVAR()
  - !SORT()
  - !USERNAME()
  - !USERNO()
  - !VIEW()
  - !VOCREC()
- QMBasic Debugger
- Process Dump Files
- Error Numbers
- Package Licensing
- Building a Self-Installing Application
- Building a CGI Web Server Application
QMClient API
System Administration
Migrating to OpenQM
System Limits
Glossary of Terms