Appendix A: Reserved Keywords

This appendix lists the following keywords:

OpenESQL reserved keywords.
ODBC reserved keywords.

A.1 OpenESQL Reserved 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	AS	AT
BEGIN	BROWSE	BY	CALL
CLOSE	COMMIT	CONCURRENCY	CONNECT
CONNECTION	CONTINUE	CUR_BROWSE	CUR_STANDARD
CURRENT	CURSOR	CURSORTYPE	DBLIBVER
DECLARE	DEFAULT	DELETE	DESCRIBE
DESCRIPTOR	DISCONNECT	DO	DYNAMIC
END	EXEC	EXECUTE	FETCH
FETCHBUFFER	FIRST	FOR	FORWARD
FOUND	FROM	GET	GO
GOTO	HOST	IDENTIFIED	IMMEDIATE
INCLUDE	INSENSITIVE	INTO	KEYSET
LAST	LOCKCC	LOGINTIME	MIXED
NEXT	NO	NOT	OF
OPEN	OPTCC	OPTCCVAL	OPTION
PERFORM	PREPARE	PRIOR	PROMPT
QUERY	READONLY	RELEASE	RESET
ROLLBACK	SAVE	SCROLL	SCROLLOPTION
SECTION	SELECT	SET	SQLCA
SQLDA	SQLERROR	SQLSERVER95	SQLWARNING
STATEMENT	UPDATE	USER	USING
WHENEVER	WITH	WORK

A.2 ODBC Reserved Keywords

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
GRANT	GROUP	HAVING	HOUR
IDENTITY	IMMEDIATE	IN	INCLUDE
INDEX	INDICATOR	INITIALLY	INNER
INPUT	INSENSITIVE	INSERT	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	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	YEAR