Keywords

The following words are recognized by OpenESQL. Not all are currently used. Some are reserved for future enhancements, or for compatibility with other Embedded SQL implementations. Absence of a word from this list does not imply that ODBC drivers which use the word are not supported.

ALL
APPLICATION
ANSI
AS
AT
AUTOCOMMIT
BEGIN
BIND
BROWSE
BY
CALL
CLOSE
COMMIT
COMMITED
CONCURRENCY
CONNECT
CONNECTION
CONTINUE
CUR_BROWSE
CUR_STANDARD
CURRENT
CURSOR
CURSORTYPE
DATABASE
DATE
DBLIBVER
DECLARE
DEFAULT
DELETE
DESCRIBE
DESCRIPTOR
DISCONNECT
DO

DSN
DYNAMIC
END
EXEC
EXECSP
EXECUTE
ESQL_VERSION
FETCH
FETCHBUFFER
FIRST
FOR
FORWARD
FOUND
FROM
GET
GO
GOTO
HDBC
HENV
HOLD
HOST
IDENTIFIED
IMMEDIATE
IN
INCLUDE
INDICATOR
INOUT
INPUT
INSENSITIVE
INTO
ISARRAY
ISOLATION
KEYSET

LAST
LIST
LOCK
LOCKCC
LOGINTIME
MIXED
NEXT
NO
NOT
OF
OFF
ON
ONLY
OPEN
OPTCC
OPTCCVAL
OPTIMISTIC
OPTION
OUT
OUTPUT
PERFORM
PREPARE
PREVIOUS
PRIOR
PROMPT
QUERY
QUERYTIME
READ
READONLY
RECOMPILE
RELEASE
REPEATABLE
RESET

RETURNING
ROLLBACK
SAVE
SCROLL
SCROLLOPTION
SECTION
SELECT
SENSITIVE
SERIALIZABLE
SET
SQLCA
SQLERROR
SQLDA
SQLSERVER95
SQLWARNING
STANDARD
STATEMENT
STATIC
TIME
TIMESTAMP
TO
TRAN
TRANSACTION
UPDATE
USER
USING
UNCOMMITED
VARIABLES
WHENEVER
WITH
WORK

The following words are reserved for use in ODBC function calls by the ODBC specification.

ABSOLUTE
ACTION
ADA
ADD
ALL
ALLOCATE
ALTER
AND
ANY
ARE
AS
ASC
ASSERTION
AT
AUTHORIZATION
AVG
BEGIN
BETWEEN
BIT
BIT_LENGTH
BOTH
BY
CASCADE
CASCADED
CASE
CAST
CATALOG
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHECK
CLOSE
COALESCE
COBOL
COLLATE
COLLATION
COLUMN
COMMIT
CONNECT
CONNECTION
CONSTRAINT
CONSTRAINTS
CONTINUE
CONVERT
CORRESPONDING
COUNT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
DATE
DAY
DEALLOCATE
DEC

DECIMAL
DECLARE
DEFAULT
DEFERRABLE
DEFERRED
DELETE
DESC
DESCRIBE
DESCRIPTOR
DIAGNOSTICS
DISCONNECT
DISTINCT
DOMAIN
DOUBLE
DROP
ELSE
END
END-EXEC
ESCAPE
EXCEPT
EXCEPTION
EXEC
EXECUTE
EXISTS
EXTERNAL
EXTRACT
FALSE
FETCH
FIRST
FLOAT
FOR
FOREIGN
FORTRAN
FOUND
FROM
FULL
GET
GLOBAL
GO
GOTO
GRANT
GROUP
HAVING
HOUR
IDENTITY
IMMEDIATE
IN
INCLUDE
INDEX
INDICATOR
INITIALLY
INNER
INPUT
INSENSITIVE
INSERT
INT
INTEGER
INTERSECT
INTERVAL
INTO

IS
ISOLATION
JOIN
KEY
LANGUAGE
LAST
LEADING
LEFT
LEVEL
LIKE
LOCAL
LOWER
MATCH
MAX
MIN
MINUTE
MODULE
MONTH
MUMPS
NAMES
NATIONAL
NATURAL
NCHAR
NEXT
NO
NONE
NOT
NULL
NULLIF
NUMERIC
OCTET_LENGTH
OF
ON
ONLY
OPEN
OPTION
OR
ORDER
OUTER
OUTPUT
OVERLAPS
PAD
PARTIAL
PASCAL
PLI
POSITION
PRECISION
PREPARE
PRESERVE
PRIMARY
PRIOR
PRIVILEGES
PROCEDURE
PUBLIC
READ
REAL
REFERENCES
RELATIVE
RESTRICT
REVOKE

RIGHT
ROLLBACK
ROWS
SCHEMA
SCROLL
SECOND
SECTION
SELECT
SEQUENCE
SESSION
SESSION_USER
SET
SIZE
SMALLINT
SOME
SPACE
SQL
SQLCA
SQLCODE
SQLERROR
SQLSTATE
SQLWARNING
SUBSTRING
SUM
SYSTEM_USER
TABLE
TEMPORARY
THEN
TIME
TIMESTAMP
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TRAILING
TRANSACTION
TRANSLATE
TRANSLATION
TRIM
TRUE
UNION
UNIQUE
UNKNOWN
UPDATE
UPPER
USAGE
USER
USING
VALUE
VALUES
VARCHAR
VARYING
VIEW
WHEN
WHENEVER
WHERE
WITH
WORK
WRITE
YEAR
ZONE