AccuTermKeywords

From Pickwiki
Jump to navigationJump to search

AccuTerm has the wED (Windows Editor) which provides syntax highlighting for BASIC programs. v7.1 allows keywords to be defined on the server. With this enhancement, a developer can open wED on different MultiValuedDatabases and get platform-specific highlighting! See the product documentation for details about how to use this feature.

This page provides lists of keywords which can be used for various platforms as well as some ideas for how the lists can be used. It is currently organized as follows:

  • General Statements are BASIC statement keywords which should be supported on all platforms. Use this as your base list.
  • General Functions are BASIC cross-platform functions. Add these to your statements list or set them as your User keywords and assign a different highlight style for more diversity in your code.
  • D3, mvBase, QM, UniVerse, etc. These sections provide platform-specific keywords for statements and functions.

Since this is a new page, please add comments to the top Comments section regarding structure, merging lists, etc. We can clean up the comments later.

If you would like to contribute to this page, edit it yourself or email TonyG with your notes.

You can help by:

  • Providing new Statement or Function keywords for specific platforms.
  • Noting when keywords should be made General or when General keywords are really platform-specific.
  • Suggesting alternative ways to make this information more useful to colleagues.

How to use these lists

Create an item called WED in ACCUTERMCTRL that looks like this:

X
ACCUTERMCTRL\KEY1
ACCUTERMCTRL\KEY2

( See AccuTerm v7.1 release notes for details on that item and additional attributes. )

Now create two more items in ACCUTERMCTRL called KEY1 and KEY2 (actual names are up to you but need to agree with item above). Copy/paste all General Statements into KEY1 (start with the ;comment). Follow those with statements for your platform. Copy/paste all General Functions into KEY2. Follow those with functions for your platform. Save the items. Now open WED and in Tools/Settings, check Enable BASIC syntax highlighting. Check the Highlight tab to ensure the colors of various code elements are easy to distinguish. Click OK to save the settings. Your code will now be highlighted using the keyword lists. Update your KEY items whenever the date below is more recent than your own.


Comments

New page: 2012-sep-6 Updated: 2012-oct-8, 10

TG:

  • Expression operators and @values added to Functions rather than Statements out of personal preference. Some people won't want these highlighted at all. Just remove them after copying to your DBMS.
  • See wED settings to understand "+", "-", and "=" suffixes.
  • Lines in keyword lists beginning with semicolon ";" are comments.
  • Lists presented here in vertical format with PRE tags for easy copy/paste into DBMS editor. Putting everything in one line would be more elegant but would then require conversion. This is just easier.
  • Lists are sorted for easy searching and for finding errors.
  • These lists are a work in progress - they are not complete. Nothing has been "forgotten". Many keywords and platforms have simply not been manually added yet. Please send your list updates to TonyG or add them here.
  • Some of the organization may be non-intuitive. For example, some Transaction statements are General and others are platform-specific. This is because some commands are found in more than one platform. When this is the case, a statement (or function) are put into the general category - the keyword may not be general across all platforms but it's general enough to be found in more than one platform, so it is not platform specific.
  • A suggestion has already been made to enhance AccuTerm to allow separation of "System" and "User" keywords into several lists which can be used for Statements, Functions, Operands, Compiler Directives, and perhaps other keyword classes.
  • There is some duplication between statements and functions, like CONVERT and LOCATE. These may be separated later.
  • It can't hurt to copy all statements from all platforms into a single list and copy that to all of your systems (same for functions).
  • Any statement or function which is on more than one platform is considered "general". The only statements and functions defined for a specific platform are those that are not found anywhere else. Entries here are subject to movement and correction.



General Statements

; Cross-platform as of 2012-oct-10
$CHAIN
$INCLUDE
ABORT
BEGIN CASE+
BEGIN TRANSACTION+
BREAK
END CASE-
COMMIT
CALL
CAPTURING
CASE=
CHAIN
CLEAR
CLEARDATA
CLEARFILE
CLEARCOMMON
CLEARINPUT
CLEARSELECT
CLOSE
CLOSESEQ
COMMIT
COMMON
COMPARE
CONVERT
CREATE
CRT
DATA
DEBUG
DEL
DELETELIST
DELETEU
DIM
DIMENSION
DO
ECHO
ELSE+
END-
END TRANSACTION-
ENTER
EQU
EQUATE
ERRMSG
ERROR
EXECUTE
FILE
FILELOCK
FILEUNLOCK
FIND
FLUSH
FOOTING
FOR+
FROM
FUNCTION
GET
GETLIST
GETX
GO
GOSUB
GOTO
HEADING
HUSH
IF
IFR
IN
INCLUDE
INPUT
INPUTERR
INPUTIF
INPUTNULL
INPUTTRAP
INS
KEY
KEYEDIT
KEYEXIT
KEYTRAP
LOCATE
LOCK
LOCKED+
LOOP+
MAT
MATBUILD
MATPARSE
MATREAD
MATREADL
MATREADU
MATWRITE
MATWRITEU
NAP
NEXT-
NOBUF
NULL
OFF
ON ERROR
ON
OPEN
OPENPATH
OPENSEQ
PAGE
PERFORM
PRECISION
PRINT
PRINTER
PRINTER RESET
PRINTERR
PROCREAD
PROCWRITE
PROGRAM
PROMPT
READ
READBLK
READL
READLIST
READNEXT
READSEQ
READT
READTX
READU
READV
READVL
READVU
RECORDLOCKL
RECORDLOCKU
RELEASE
REMOVE
REPEAT-
RETURN
RETURNING
REWIND
ROLLBACK
RQM
SEEK
SELECT
SELECTE
SELECTINDEX
SETREM
SLEEP
STEP
STOP
SUB
SUBROUTINE
TA
TCLREAD
THEN+
TIMEOUT
TO
TRANSACTION START+
TTYSET
UNLOCK
UNTIL=
WEOF
WEOFSEQ
WHILE=
WRITE
WRITET
WRITEU
WRITEV
WRITEVU

General Functions

; Cross-platform
@AM
@FM
@SM
@VM
ABS
ABSS
ACOS
ALPHA
AND
ANDS
ASCII
ASIN
ASSIGNED
ATAN
BITAND
BITNOT
BITOR
BITRESET
BITSET
BITTEST
BITXOR
CAT
CATS
CHANGE
CHECKSUM
CHAR
COL1
COL2
COS
CONVERT
COUNT
COUNTS
DATE
DCOUNT
DELETE
DIV
DOWNCASE
DQUOTE
DTX
EBCDIC
ENCRYPT
EQS
EREPLACE
EXCHANGE
EXP
EXTRACT
FIELD
FILEINFO
FMT
FMTS
FOLD
GE
GES
GETREM
GT
ICONV
IFS
INDEX
INDEXS
INDICES
INMAT
INSERT
INT
ITYPE
KEYIN
LE
LEN
LENS
LES
LG
LN
LOCATE
LOWER
LT
LTS
MATCH
MATCHFIELD
MAXIMUM
MINIMUM
MOD
MODS
NE
NEG
NEGS
NES
NOT
NOTS
NUM
NUMS
OCONV
OCONVS
OR
ORS
PWR
RAISE
REM
REPLACE
REUSE
RND
SEEK
SELECTINFO
SENTENCE
SEQ
SIN
SORT
SOUNDEX
SPACE
SQRT
SQUOTE
STATUS
STR
STRS
SUM
SUMMATION
SWAP
SYSTEM
TAN
TERMINFO
TIME
TIMEDATE
TRANS
TRIM
TRIMB
TRIMBS
TRIMF
TRIMFS
UNASSIGNED
XLATE
XTD


D3

Statements

; D3-Specific
$OPTIONS
AUX
BEGIN WORK+
CASING ON
CASING OFF
CFUNCTION
COMMIT WORK
END WORK-
INPUTCTRL
ROOT
SEND
SENDX
TRANSACTION CACHE OFF
TRANSACTION CACHE ON
TRANSACTION FLUSH
TRANSACTION ROLLBACK

Functions

; D3-Specific
ACCESS
ERROR
OCCURS
SCAN


mvBase

Statements

; mvBase-Specific
$*
BLOCK
BREAKKEY ON
BREAKKEY OFF
CONNECT
CONSOLE
CRT ON
DISCONNECT
INPUT CTRL ON
INPUT CTRL OFF
INPUTPROMPT
LOCK-BEEP
READB
READF
SPOOLQ
UCLOSE
UCREATE
UDELETE
UERROR
UEXECUTE
ULOCK
ULSEEK
UMESSAGE
UNBLOCK
UOPEN
UREAD
UREADLINE
USING
USYSTEM
UWAITFOR
UWRITE
WAKEUP
WRITEB
WRITEBU
WRITEFU

Functions

; mvBase-Specific
LINESTATUS


QM

Statements

; QM-specific
ABORTE
ABORTM
CLASS
CREATE.FILE
DEFFUN
DELETE
DELETESEQ
DIR
DISINHERIT
DISPLAY
DPARSE
DPARSE.CSV
EXIT
FINDSTR
FORMLIST
GETPU
INHERIT
INPUTCLEAR
INPUTCSV
INPUTFIELD
LOGMSG
LOCAL
MARK.MAPPING
MATREADCSV
OS.EXECUTE
OSDELETE
OSREAD
OSWRITE
PAUSE
PRINTER NAME
PRINTER SETTING
PRIVATE
PUBLIC
READCSV
REMARK
REMOVE.BREAK.HANDLER
RESTORE.SCREEN
SAVELIST
SELECTLEFT
SELECTN
SELECTRIGHT
SELECTV
SET.ARG
SET.BREAK.HANDLER
SET.EXIT.STATUS
SETLEFT
SETPU
SETRIGHT
SSELECT
STOPE
STOPM
WAKE
WEOFSEQF
VOID

Functions

; QM-specific
ACCEPT.SOCKET.CONNECTION
ARG
ARG.COUNT
BINDKEY
CATALOGED
CATALOGUED
CHILD
CLOSE.SOCKET
COMPARE
CONFIG
CONNECT.PORT
CREATE.SERVER.SOCKET
CROP
CSVDQ
DECRYPT
ENV
FIELDS
FIELDSTORE
FOLDS
GET.MESSAGES
GET.PORT.PARAMS
GETNLS
GTS
ICONVS
IDIV
KEYCODE
KEYINC
KEYINR
KEYREADY
LISTINDEX
MATCHESS
MAX
MIN
OBJECT
OBJINFO
OPEN.SOCKET
OS.ERROR
OUTERJOIN
PRINTER.SETTING
QUOTE
RDIV
READ.SOCKET
READLOCKED
REMOVE
REMOVEF
RTRANS
SAVE.SCREEN
SERVER.ADDR
SET.PORT.PARAMS
SET.SOCKET.MODE
SETNLS
SHIFT
SOCKET.INFO
SOUNDEXS
SPACES
SPLICE
SUBR
SUBSTITUTE
SUBSTRINGS
SWAPCASE
TRIMS
TTYGET
VSLICE
WRITE.SOCKET


Unidata

Statements


Functions



Universe

Statements

; Universe-Specific
$MAP
AUTHORIZATION
AUXMAP
BSCAN
CAT
CONTINUE
FILELOCK
FILEUNLOCK
GETX
GROUPSTORE
INPUTDISP
INPUTDP
OPENCHECK
OPENDEV
RANDOMIZE
READLOCKED
RECORDLOCKL
RECORDLOCKU
REVREMOVE
SEND
SET TRANSACTION ISOLATION LEVEL
STATUS
SUBR
TABSTOP
TTYCTL
TTYGET
WRITEBLK
WRITELIST
WRITESEQ
UPRINT

Functions

; Universe-Specific
acceptConnection
ADDS
BYTE
BYTELEN
BYTETYPE
BYTEVAL
CENTURY.PIVOT
CHARS
CLEARPROMPTS
closeSocket
[[CloseXMLData]]
COSH
DIGEST
DIVS
ENCODE
EOF
EXP
FADD
FDIV
FFIX
FFLT
FIX
FMTDP
FMTDSP
FMUL
FOLDDP
FSUB
GET
getHTTPDefault
GETLOCALE
get[[SocketErrorMessage]]
get[[SocketInformation]]
get[[SocketOptions]]
GROUP
ICHECK
ILPROMPT
INCONVS
ISNULL
ISNULLS
LEFT
LENDP
LENSDP
LOCALEINFO
MULS
[[OpenXMLData]]
[[PrepareXML]]
protocolLogging
RECORDLOCKED
readSocket
[[ReadXMLData]]
REAL
[[ReleaseXML]]
RIGHT
RPC.CALL
RPC.CONNECT
RPC.DISCONNECT
SADD
SCMP
SDIV
SEQS
setHTTPDefault
SETLOCALE
set[[RequestHeader]]
set[[SocketOptions]]
SIGNATURE
SINH
SMUL
SSUB
SUBS
TANH
TPARM
TPRINT
UNICHAR
UNICHARS
UNISEQ
UNISEQS
UPCASE
writeSocket
XLATE
XMLError

jBASE

Statements

; jBASE-Specific
ALL
APPEND
APPENDING
ARG
AT
ATKEY
ATVAR
BEFORE
BEGIN+
BFUNC
BLOB
BY
CALLC
CALLJ
CASING
CE
CFUNC
CHANGETIMESTAMP
COLLECTDATA
CONTINUE
CONTROLCHAR
CRC
CTYPE
DE
DECLARE
DEFB
DEFC
DEFCE
DEFCPP
DEFFUN
DELENV
DELETESEQ
EDYN
ENVFUNC
EOL
EQ
ERRTEXT
EXEC
EXISTING
EXIT
FFIX
FFLT
FINDSTR
FLOAT
FORMLIST
GETUSERGROUP
GETUSERNAME
GROUPSTORE
GTS
HEADINGE
HEADINGN
INPUTCLEAR
IOCTL
JBASECOREDUMP
JQLCLOSESTATMENT
JQLCOMPILE
JQLEXECUTE
JQLFETCH
JQLGETPROPERTY
JQLPUTPROPERTY
LOC_SDYN
LP
LPTR
MATVAR
MDPERFORM
ME
MM
MSG
MSLEEP
MTU
OPENDEV
OPENINDEX
OPENSER
OSBREAD
OSBWRITE
OSCLOSE
OSDELETE
OSOPEN
OSREAD
OSWRITE
OUT
PASSDATA
PASSLIST
PAUSE
PCPERFORM
PE
PERROR
POSCUR
PP
RANDOMIZE
READONLY
READPREV
READSELECT
READX
READXL
READXML
READXMLU
READXU
RESET
RTNDATA
RTNLIST
SDYN
SECTION
SEND
SENDX
SETTING
SMALLINT
SQL
SSELECT
SSELECTN
SSELECTV
START
STATIC
STRING
SUBR
SYNC
TABLE
TE
TRANSABORT
TRANSEND
TRANSSYNC
TRANSTART
TTYCTL
TTYGET
UDTEXECUTE
UNFILTERED
UNIT
USING
VAR
VARARG
VARCHAR
WAITING
WAKE
WITH
WRITEBLK
WRITELIST
WRITEP
WRITEPU
WRITESEQ
WRITESEQF
WRITETX
WRITEX
WRITEXML
WRITEXU
XMLADDNODE
XMLADDTEXT
XMLGETTAGVALUE
XMLREMOVETAGVALUE
XMLVALIDATE

Functions

; jBASE-Specific
ADDS
BITCHANGE
BITCHECK
BITLOAD
BYTELEN
CALLONEXIT
CHARS
CHDIR
DECRYPT
DIR
DIVS
DROUND
DYNTOXML
FADD
FCMP
FDIV
FIELDS
FMUL
FSUB
GETCWD
GETENV
GROUP
ICONVS
ISALNUM
ISALPHA
ISCNTRL
ISDIGIT
ISGRAPH
ISLOWER
ISPRINT
ISPUNCT
ISSPACE
ISUPPER
ISXDIGIT
LATIN1
LEFT
LENDP
LENGTH
LENSDP
LOCALDATE
LOCALTIME
LOWCASE
MAKETIMESTAMP
MATCHES
MULS
OBJEXCBACK
PUTENV
RECORDLOCKED
REGEXP
RIGHT
SADD
SCMP
SDIV
SEQS
SMUL
SPACES
SPLICE
SPOOLER
SSUB
SUBS
SUBSTRINGS
TIMEDIFF
TIMESTAMP
TRANSQUERY
TRIMS
UNIQUEKEY
UPCASE
UTF8
WRITEXMLU
XMLTODYN
XMLTOXML


Add more DBMS platforms here