Recital SQL Reference Guide
Upgrading From Pre-9.4 Versions
Upgrading From Pre-9.0 Versions
Xbase Migration
Recital 4GL
Environment
ASCII Chart
Constants, Variables and Operators
Constants and Expressions
Logical Operators
Mathematical Operators
Memory Variables
Parameter Passing
Relational Operators
Special Purpose Operators
Default File Extensions
Encryption
Error Handling
C-ISAM RDD Error Messages
Error Handling & Debugging
Recital/4GL Error Messages
Recital/SQL Error Messages
Recital Database and Mirage Server Error Messages
Xbase RDD Error Messages
Extensible Markup Language (XML)
Function Keys in Forms & Worksurfaces
National Character Sets
Non-Recital File Formats
Using C-ISAM Files
C-ISAM RDD Error Messages
Using RMS Files
Using Xbase Data Files
Xbase RDD Error Messages
Optimizing Indexes with SYNCNUM
Printing
Recital/4GL Basics
Upgrading
Upgrading dbx Indexes from Pre-8.3 Versions
Upgrading From Pre-8.0 Versions
Utilities and Scripts
Commands invoked from the Operating System
DBEXEC - Running background UAS programs
Recital Linker
Users Files
Commands
\ | \\
!
!!
++
--
&&
*
//
/*...*/
:=
;
? | ??
???
@
@...BOX
@...CLEAR
@…EDIT
@...FILL
@...GET
@…GET – Check Boxes
@…GET - Lists
@…GET - Popups
@…GET – Push Buttons
@…GET – Radio Buttons
@…GET…SPINNER
@...MENU
@...PROMPT
@...SAY
@…SAY…BITMAP
@...SCROLL
@...TO
ACCEPT
ACTIVATE MENU
ACTIVATE POPUP
ACTIVATE SCREEN
ACTIVATE WINDOW
ALIAS
APPEND
APPEND AUTOMEM
APPEND BLANK
APPEND FROM ARRAY
APPEND FROM
APPEND MEMO
ASSERT
AVERAGE
BEGIN SEQUENCE
BEGIN TRANSACTION
BLANK
BROWSE
BUILD
CALCULATE
CALCULATOR
CALENDAR
CANCEL
CHANGE
CLASS
CLASS - Methods
CLASS - Parameters
CLASS - Properties
CLASS - Scoping
CLEAR
CLEAR ALL
CLEAR AUTOMEM
CLEAR FCACHE
CLEAR GETS
CLEAR IOSTATS
CLEAR KEYS
CLEAR LOCKS
CLEAR MEMORY
CLEAR MENUS
CLEAR POPUPS
CLEAR PROGRAM
CLEAR PROMPT
CLEAR READ
CLEAR SCREEN
CLEAR TYPEAHEAD
CLEAR WINDOWS
CLOSE
CLOSE ALL
CLOSE ALTERNATE
CLOSE DATABASES
CLOSE FORMAT
CLOSE INDEX
CLOSE PROCEDURE
CLOSE TABLES
COMPILE
COMPILE DATABASE
CONTINUE
CONVERT
COPY DICTIONARY TO
COPY FILE
COPY INDEXES
COPY MEMO
COPY STRUCTURE EXTENDED
COPY STRUCTURE
COPY TAG
COPY TO
COPY TO ARRAY
COUNT
CREATE
CREATE BRIDGE
CREATE DICTIONARY FROM
CREATE FROM
CREATE GATEWAY
CREATE LABEL
CREATE REPORT
CREATE SCREEN
CREATE VIEW
DEACTIVATE MENU
DEACTIVATE POPUP
DEACTIVATE WINDOW
DEBUG
DECLARE
DECRYPT
#DEFINE
DEFINE BAR
DEFINE CLASS
DEFINE MENU
DEFINE PAD
DEFINE POPUP
DEFINE TABLE
DEFINE WINDOW
DELETE
DELETE FILE
DELETE TAG
DESIGN
DIALOG BOX
DIALOG FIELDS
DIALOG FILES LIKE
DIALOG GET
DIALOG MESSAGE
DIALOG QUERY
DIALOG SCOPE
DIMENSION
DIR
DISPLAY
DISPLAY DATABASE
DISPLAY DICTIONARY
DISPLAY FILES
DISPLAY HISTORY
DISPLAY INDEXES
DISPLAY MEMORY
DISPLAY PROCEDURE
DISPLAY PROTECTION
DISPLAY REPORT
DISPLAY STATUS
DISPLAY STRUCTURE
DISPLAY TABLES
DISPLAY TRIGGERS
DISPLAY USERS
DO
DO CASE
DO WHILE
ED
EDIT
EJECT
END TRANSACTION
ENDFUNC
ENCRYPT
ENDPROC
ERASE
ERROR
EXIT
EXTERNAL
FIND
FLUSH
FOR ... NEXT
FUNCTION
GATHER
GENERATE
GOTO
HELP
HIDE POPUP
HIDE WINDOW
IF
#IF
#IFDEF
INDEX ON
#INCLUDE
INFO
INPUT
INSERT
INSTALL
JOIN
KEYBOARD
KEYWORD
LABEL
LINK
LIST
LIST DATABASE
LIST DICTIONARY
LIST FILES
LIST HISTORY
LIST INDEXES
LIST MEMORY
LIST PROCEDURE
LIST PROTECTION
LIST REPORT
LIST STATUS
LIST STRUCTURE
LIST TABLES
LIST TRIGGERS
LIST USERS
LOCAL
LOCATE
LOCKF
LOCKR
LOGIN
LOGOUT
LOOP
LPARAMETERS
MENU
MENU AT
MENU BAR
MENU BROWSE
MENU COMMAND
MENU FIELDS
MENU FILES LIKE
MENU FORMAT
MENU FRAME
MENU FROM
MENU QUERY
MENU SCOPE
MENU TO
MESSAGE
METHOD
MODIFY BRIDGE
MODIFY COMMAND
MODIFY FILE
MODIFY GATEWAY
MODIFY LABEL
MODIFY MEMO
MODIFY REPORT
MODIFY SCREEN
MODIFY STRUCTURE
MODIFY VIEW
MOVE WINDOW
NOEXIT
NOTE
ON BAR
ON ERROR
ON ESCAPE
ON EXIT BAR
ON EXIT MENU
ON EXIT PAD
ON EXIT POPUP
ON FINISH
ON KEY
ON MAIL
ON MENU
ON MOUSE
ON PAD
ON PAGE
ON POPUP
ON READERROR
ON SELECTION BAR
ON SELECTION MENU
ON SELECTION PAD
ON SELECTION POPUP
ON TERMINATION
ON TIMEOUT
PACK
PARAMETERS
POP KEY
POP MENU
POP POPUP
PRINT
PRIVATE
PROCEDURE
PUBLIC
PUSH KEY
PUSH MENU
PUSH POPUP
QUERY
QUIT
READ
READ MENU BAR TO
READ MENU TO
RECALL
RECOVER
REINDEX
RELEASE
RELEASE LIBRARY
RELEASE MENUS
RELEASE POPUPS
RELEASE WINDOWS
RENAME
REPLACE
REPLACE AUTOMEM
REPLAY
REPORT
RESET IN
RESIZE WINDOW
RESTORE
RESTORE COLOR
RESTORE GETS
RESTORE KEYS
RESTORE MENU
RESTORE RECORDVIEW
RESTORE SCREEN
RESTORE WINDOW
RESUME
RETRY
RETURN
ROLLBACK
RUN
SAVE COLOR
SAVE ERROR
SAVE GETS
SAVE KEYS
SAVE MENU
SAVE_RECORDVIEW
SAVE SCREEN
SAVE TO
SAVE WINDOW
SCAN
SCATTER
SCROLL
SEEK
SELECT
SHOW GET
SHOW GETS
SHOW MENU
SHOW OBJECT
SHOW POPUP
SHOW WINDOW
SKIP
SLEEP
SORT
SPAWN
STORE
STORE AUTOMEM
SUM
SUSPEND
TEXT
TOTAL
TREPORT
TYPE
TRY...ENDTRY
#UNDEF
UNLOCK
UPDATE
USE
VI
WAIT
WITH
ZAP
Functions
&
AAVERAGE()
AADD()
ABROWSE()
ABS()
ACC()
ACCESS()
ACHOICE()
ACLASS()
ACOL()
ACOPY()
ACOS()
ACTIVEPID()
ADATABASES()
ADDBS()
ADDPROPERTY()
ADEL()
ADESC()
ADIR()
AELEMENT()
AFIELDS()
AFILL()
AFONT()
AINS()
ALEN()
ALIAS()
ALLTRIM()
ALTD()
AMAX()
AMEMBERS()
AMIN()
AMPM()
AROW()
ASC()
ASCAN()
ASIN()
ASIZE()
ASORT()
ASTORE()
ASTRING()
ASUBSCRIPT()
ASUM()
AT()
ATAN()
ATN2()
ATNEXT()
AVGVALUES()
BAR()
BARCOUNT()
BARPROMPT()
BASENAME()
BETWEEN()
BIN2I()
BIN2L()
BIN2W()
BINCLOSE()
BINCREATE()
BINOPEN()
BINREAD()
BINSEEK()
BINWRITE()
BITAND()
BITCLEAR()
BITLSHIFT()
BITNOT()
BITOR()
BITRSHIFT()
BITSET()
BITTEST()
BITXOR()
BLINK()
BOF()
BOLD()
BRIDGE()
CAGR()
CALC()
CANCELPID()
CANDIDATE()
CATALOG()
CAPSLOCK()
CAST()
CDOW()
CDX()
CEILING()
CENTER() | CENTRE()
CERROR()
CHANGE()
CHR()
CHROVERLAP()
CHRTRAN()
CLEARRESULTSET()
CLOSEMAIL()
CMONTH()
CNTVALUES()
COL()
COLLATE()
COMPLETED()
COMPOBJ()
CONNECTED()
COPYFILEFROM()
COPYFILETO()
COS()
COUNTMAIL()
CREATEOBJECT()
CTOD()
CTOT()
CTRL()
CURDIR()
CURRENCY()
CURRSEQNO()
CURSORNAME()
DATABASE()
DATE()
DATETIME()
DAY()
DAYS()
DBEDIT()
DBF()
DBFILTER()
DBRELATION()
DBRSELECT()
DBUSED()
DBXDESCEND()
DEFAULT()
DELETED()
DELETEMAIL()
DESCEND()
DESCENDING()
DIFFERENCE()
DIR()
DISKSPACE()
DMY()
DODEFAULT()
DOLEVEL()
DOSERROR()
DOW()
DTOC()
DTOM()
DTOR()
DTOS()
DTOV()
EDITFIELD()
ELAPTIME()
EMPTY()
EOF()
EPOCH()
ERRNO()
ERROR()
ERRORLEVEL()
ETOS()
EVALUATE()
EXCLUSIVE()
EXEC()
EXECSCRIPT()
EXP()
EXPRCHECK()
FCLOSE()
FCOUNT()
FCREATE()
FDATE()
FEOF()
FERROR()
FFLUSH()
FGETS()
FIELD()
FIELDNAME()
FILE()
FILECOUNT()
FILEINFO()
FILETOSTR()
FILETYPE()
FILTER()
FINDCURSOR()
FIXED()
FKLABEL()
FKMAX()
FLDCOUNT()
FLDLIST()
FLOAT()
FLOCK()
FLOOR()
FMT()
FONTMETRIC()
FOPEN()
FOR()
FOUND()
FPUTS()
FREAD()
FREADSTR()
FSEEK()
FSIZE()
FTIME()
FULLPATH()
FV()
FWRITE()
GATEWAY()
GETENV()
GETFILE()
GETFONT()
GETGID()
GETGRNAM()
GETLOCALHOST
GETLOG()
GETNO()
GETPID()
GETPROT()
GETREMOTEADDR()
GETREMOTEHOST()
GETREMOTEUSER()
GETRESULTSET()
GETSIG()
GETUID()
GOMONTH()
GOTO()
HARDCR()
HEADER()
HOME()
HOUR()
HOURS()
HSCROLL()
I2BIN()
ICACHE()
ICASE()
ID()
IF()
IFILECOUNT()
IIF()
INDEXEXT()
INDEXKEY()
INDEXORDER()
INKEY()
INLIST()
INSMODE()
INT()
INUSE()
IOSTATS()
ISALPHA()
ISBLANK()
ISCOLOR()
ISDIGIT()
ISFILTERED()
ISLOCKED()
ISLOWER()
ISMARKED()
ISMIRAGE()
ISMOUSE()
ISNULL()
ISPRINTER()
ISSERVER()
ISUPPER()
KEY()
KEYMATCH()
L2BIN()
LASTKEY()
LASTREC()
LEFT()
LEN()
LENNUM()
LIKE()
LINENO()
LKSYS()
LOCK()
LOG()
LOG10()
LOOKUP()
LOWER()
LPAD()
LTOS()
LTRIM()
LUPDATE()
MAIL()
MAILCLOSE()
MAILCOUNT()
MAILDELETE()
MAILERROR()
MAILHEADER()
MAILNODENAME()
MAILOPEN()
MAILREAD()
MAILSEND()
MAILUSERNAME()
MAX()
MAXCOL()
MAXROW()
MAXVALUES()
MCOL()
MDX()
MDY()
MEMLINES()
MEMOEDIT()
MEMOLINE()
MEMOREAD()
MEMORY()
MEMOSAY()
MEMOTRAN()
MEMOWRITE()
MENU()
MENUITEM()
MESSAGE()
MESSAGEBOX()
MIN()
MINUTE()
MINUTES()
MINVALUES()
MLCOUNT()
MLINE()
MOD()
MONTH()
MROW()
MTOD()
MTOS()
NDX()
NEWOBJECT()
NETERR()
NETNAME()
NETWORK()
NEXTKEY()
NFCOUNT()
NUMLOCK()
NVL()
OBJECTREAD()
OBJECTTYPE()
OBJECTWRITE()
OCCURS()
ON()
OPENMAIL()
ORDER()
OS()
PAD()
PADC()
PADL()
PADPROMPT()
PADR()
PARAMETERS()
PATH()
PAYMENT()
PCOL()
PCOUNT()
PERCENT()
PEXIST()
PI()
PMT()
POPUP()
PRINTFILE()
PRINTSCREEN()
PRINTSTATUS()
PRMBAR()
PROCLIBS()
PROCLINE()
PROCNAME()
PROGRAM()
PROMPT()
PROPER()
PROW()
PUTENV()
PUTFILE()
PUTLOG()
PV()
QUARTER()
RAND()
RANK()
RAT()
READEXIT()
READINSERT()
READKEY()
READMAIL()
READMODE()
READVAR()
RECCOUNT()
RECNO()
RECSIZE()
REFERENCES()
RELATION()
REMOVEPROPERTY()
REPLACE()
REPLICATE()
REQUIRE()
REQUIRE_ONCE()
RESTSCREEN()
REVERSE()
RIGHT()
RLOCK()
RLOOKUP()
ROLLBACK()
ROUND()
ROW()
RPAD()
RTOD()
RTRIM()
RUN()
SAVESCREEN()
SCHEME()
SCOLS()
SCROLL()
SEC()
SECONDS()
SECS()
SEEK()
SELECT()
SENDMAIL()
SEQNO()
SET()
SETCANCEL()
SETCOLOR()
SETPRC()
SETPROT()
SETRESULTSET()
SHOWDOCUMENT()
SIGN()
SIN()
SOUNDEX()
SPACE()
SPAWNPID()
SQLVALUES()
SQRT()
SROWS()
STOD()
STR()
STRCOMPARE()
STREXTRACT()
STRTOFILE()
STRTRAN()
STRZERO()
STUFF()
SUBSTR()
SUMVALUES()
SYS()
TAG()
TAGCOUNT()
TAGNO()
TAN()
TARGET()
TEXTEDIT()
TIME()
TIMESTAMP()
TMPNAM()
TONE()
TRANSFORM()
TRIM()
TSPOS()
TSTRING()
TSWORD()
TTOC()
TTOD()
TXNISOLATION()
TXNLEVEL()
TYPE()
UNDERLINE()
UNIQUE()
UNIQUEROWID()
UPDATED()
UPPER()
USED()
USER()
USERLOG()
VAL()
VALIDTIME()
VARREAD()
VARTYPE()
VERSION()
VTOD()
WCOLS()
WEEK()
WEXIST()
WFONT()
WINDOW()
WONTOP()
WORKAREA()
WOUTPUT()
WROWS()
WTITLE()
WVISIBLE()
XMLCOUNT()
XMLCREATEDTD()
XMLFIRST()
XMLNEXT()
XMLVALIDATE()
YEAR()
Set Commands
SET ALTERNATE
SET ASSERTS
SET AUTOCATALOG
SET AUTOFORMAT
SET AUTOJOIN
SET AUTOSAVE
SET BELL
SET BLINK
SET BLOCKSIZE
SET BORDER
SET CACHELOAD
SET CAPTURE
SET CARRY
SET CATALOG
SET CENTURY
SET CLASSLIBRARY
SET CLEAR
SET CLIPPER
SET CLIPPER5
SET CLOCK
SET CLOCKDISPLAY
SET CLOCKRATE
SET COLOR OF
SET COLOR
SET COMMAND
SET COMMANDWINDOW
SET COMPATIBLE
SET COMPILE
SET CONFIRM
SET CONSOLE
SET CURRENCY
SET CURSOR
SET DATE
SET DBTRAP
SET DCACHE
SET DEBUG
SET DECIMALS
SET DEFAULT
SET DELETED
SET DELIMITERS
SET DESCRIPTIONS
SET DESIGN
SET DEVELOPMENT
SET DEVICE
SET DIALOG
SET DICTIONARY
SET DIRECTORY
SET DISPLAY
SET DOESCAPE
SET DOHISTORY
SET ECHO
SET EDITFIELD
SET EMACROS
SET ENCRYPTION
SET EPOCH
SET ERRORVERSION
SET ERRORWINDOW
SET ESCAPE
SET EXACT
SET EXCLUSIVE
SET FASTINDEX
SET FCACHE
SET FIELDS
SET FIELDVAL
SET FILECASE
SET FILETYPE
SET FILTER
SET FIXED
SET FKLABEL
SET FORMAT
SET FORMSTATE
SET FORMUPDATE
SET FULLPATH
SET FUNCTION
SET GATEWAY
SET GCACHE
SET HEADING
SET HELP
SET HELPFILE
SET HELPWINDOW
SET HIDDENFIELD
SET HIGHLIGHT
SET HISTORY
SET HISTPATH
SET HOURS
SET IBLOCK
SET ICACHE
SET INDEX
SET INDEXEXT
SET INKEYDELAY
SET INSTRUCT
SET INTENSITY
SET JOURNAL
SET KBEDIT
SET KEY TO
SET KEY...TO
SET KEYWORD
SET LANGUAGE
SET LDCHECK
SET LIBRARY
SET LOCKTYPE
SET LOCKWAIT
SET MACKEY
SET MACROS
SET MAIL
SET MAPCHAR
SET MARGIN
SET MARK
SET MAXDBO
SET MBLOCK
SET MCONFIRM
SET MEMOCLEAR
SET MEMOEXT
SET MEMOFORMAT
SET MEMOJOURNAL
SET MEMOSOFTCR
SET MEMOWIDTH
SET MEMOWINDOW
SET MENU
SET MENUBAR
SET MESSAGE
SET MOUSE
SET MULTIUSER
SET NAVIGATE
SET NEAR
SET NOTIFY
SET NULL
SET NULLDISPLAY
SET ODOMETER
SET ONERROR
SET OPTIMIZE
SET OPTLOG
SET ORDER
SET PAGELENGTH
SET PAGEWIDTH
SET PATH
SET PAUSE
SET PCACHE
SET PCEDIT
SET PCEXACT
SET PCFILTER
SET PCFKEYS
SET PCGRAPHICS
SET PCKEYS
SET PCLOCKING
SET PCPICTURE
SET PCSAYS
SET PCUNIQUE
SET PERFDIAL
SET PERFMETER
SET POINT
SET POSTFORM
SET POSTMENU
SET POSTRECORD
SET PRECISION
SET PREFORM
SET PREMENU
SET PRERECORD
SET PRINT
SET PRINTER
SET PROCEDURE
SET PROMPT
SET PSHARE
SET QUERYMODE
SET READEXIT
SET READINSERT
SET REFRESH
SET RELATION
SET REPROCESS
SET RETAINMENU
SET ROLLBACK
SET RUNCLEAR
SET RUNWAIT
SET SAFETY
SET SCHEDULE
SET SCOREBOARD
SET SCREENCAPTURE
SET SCREENIO
SET SCREENMAP
SET SCROLL
SET SECONDS
SET SEPARATOR
SET SEQNO
SET SHADOW
SET SKIP
SET SOFTSEEK
SET SPACE
SET SQL
SET SQLPROMPT
SET STATUS
SET STEP
SET STRINGBUF
SET STRINGLEN
SET SYSLOGGING
SET SYSMENU
SET TALK
SET TBUFSIZE
SET TCACHE
SET TEDIT
SET TERMINAL
SET TEXTMERGE
SET TIME
SET TIMEOUT
SET TITLE
SET TMPDIR
SET TRACEWINDOW
SET TRANSACTION
SET TRAP
SET TSLENGTH
SET TYPEAHEAD
SET UDFPARMS
SET UICONTROLS
SET UNDERLINE
SET UNIQUE
SET UPDATE
SET VALIDATE
SET VAXTIME
SET VERIFY
SET VIEW
SET WINDOW OF BROWSE
SET WINDOW OF EDIT
SET WINDOW OF MEMO
SET WINDOW OF RELATION
SET WP
SET WRAP
SET XMLFORMAT
Environment Variables
DB_ADDNEWLINE
DB_COMPMULICOMM
DB_CONFIG
DB_DATADIR
DB_DATE
DB_ENCRYPTION
DB_ERRORDIR
DB_FILECASE
DB_FIRECATLOG
DB_FOXMEM
DB_FOXPLUSBUGS
DB_FOXPROKEYS
DB_HOSTNAME
DB_HTTP_ALLOW
DB_HTTP_DENY
DB_INDEXSEQNO
DB_LICENSE_SERVER
DB_LOCAL_LOGIN
DB_LOGDIR
DB_LOGVER
DB_MAXROW
DB_MAXWKA
DB_MIRAGE
DB_MIRAGE_COMMAND
DB_MIRAGE_CONFIG
DB_MIRAGE_DIRECTORY
DB_MIRAGE_PATH
DB_NOCALCULATOR
DB_NOCALENDAR
DB_NOPAM
DB_ODBC_INI
DB_OPTLOG
DB_PRINTEREJECT
DB_PRINTERROR
DB_REREAD_COLORFILE
DB_RUNLOG
DB_RUNOPTS
DB_RUNOPTS2
DB_SAMBA
DB_SAVEHISTORY
DB_TMPDIR
DB_TSINDEX
DB_UAS_ALLOW
DB_UAS_DENY
DB_UNIXPATH
DB_USERLOG
DB_XMLREP
Recital SQL
Environment
OVERVIEW
DATA TYPES
System Tables
SYSACTIVEUSERS
SYSBESTROWIDENTIFIER
SYSCATALOGS
SYSCOLUMNCONSTRAINTS
SYSCOLUMNPRIVILEGES
SYSCOLUMNS
SYSCROSSREFERENCE
SYSEXPORTEDKEYS
SYSIMPORTEDKEYS
SYSINDEXINFO
SYSIOSTATS
SYSLOGGING
SYSPRIMARYKEYS
SYSPROCEDURECOLUMNS
SYSPROCEDURES
SYSRESULTSET
SYSSCHEMAS
SYSTABLECONSTRAINTS
SYSTABLEPRIVILEGES
SYSTABLES
SYSTABLETYPES
SYSTYPEINFO
SYSUDTS
SYSVERSIONCOLUMNS
Pseudo Columns
CURRVAL
NEXTVAL
ROWID
ROWNUM
SQLCNT
SQLCODE
SYNCNUM
Operators
NUMERIC OPERATORS
STRING OPERATORS
DATE OPERATORS
LOGICAL OPERATORS
RELATIONAL OPERATORS
Predicates
BETWEEN PREDICATE
IN PREDICATE
LIKE PREDICATE
NULL PREDICATE
Column Constraints
AUTO_INCREMENT
AUTOINC
CALCULATED
CHECK
DEFAULT
DESCRIPTION
ERROR
FOREIGN_KEY
NOCPTRANS
NOT_NULL
NULL
PRIMARY_KEY
RANGE
RECALCULATE
REFERENCES
SET_CHECK
UNIQUE
Table Constraints
CHECK
ERROR
FOREIGN_KEY
INDEX
KEY
ONCLOSE
ONDELETE
ONINSERT
ONOPEN
ONROLLBACK
ONUPDATE
PRIMARY_KEY
UNIQUE
Commands
ADD TABLE
ALTER INDEX
ALTER TABLE
BACKUP DATABASE
BEGIN TRANSACTION
CLOSE
CLOSE DATABASES
CLOSE TABLES
COMMIT
COMPILE DATABASE
CREATE BRIDGE
CREATE CONNECTION
CREATE CURSOR
CREATE DATABASE
CREATE INDEX
CREATE PROCEDURE
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
DECLARE CURSOR
DELETE
DELETE TRIGGER
DISPLAY DATABASE
DISPLAY TABLES
DROP BRIDGE
DROP CONNECTION
DROP CURSOR
DROP DATABASE
DROP INDEX
DROP PROCEDURE
DROP VIEW
END TRANSACTION
EXEC SQL
EXECUTE
EXECUTE IMMEDIATE
FETCH
GRANT
INSERT
LIST DATABASE
LIST TABLES
LOCK TABLE
OPEN
OPEN DATABASE
PACK DATABASE
PREPARE
REBUILD DATABASE
REINDEX DATABASE
RESTORE DATABASE
REVOKE
ROLLBACK
SAVE TRANSACTION
SAVEPOINT
SELECT
UPDATE
USE
Functions
Standard Recital Functions
Remote Data Connectivity Functions
SQLCANCEL()
SQLCOLUMNS()
SQLCOMMIT()
SQLCONNECT()
SQLDISCONNECT()
SQLEXEC()
SQLGETPROP()
SQLMORERESULTS()
SQLPREPARE()
SQLROLLBACK()
SQLSETPROP()
SQLSTRINGCONNECT()
SQLTABLES()
Aggregate Functions
AVG()
COUNT()
MAX()
MIN()
SUM()
Set Commands
SET...
SET AUTOCATALOG
SET CENTURY
SET GATEWAY
SET HOURS
SET NULL
SET NULLDISPLAY
SET SECONDS
SET SEQNO
SET SQL
SET SQLPROMPT
SET SQLROWID
SET TCACHE
SET TRANSACTION
SET XMLFORMAT