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	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	STATIC
TIME	TIMESTAMP	TO	TRAN
TRANSACTION	UPDATE	USER	USING
UNCOMMITED	VARIABLES	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
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	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	POSITION	PRECISION
PREPARE	PRESERVE	PRIMARY	PRIOR
PRIVILEGES	PROCEDURE	PUBLIC	READ
REAL	REFERENCES	RELATIVE	RESTRICT
REVOKE	RIGHT	ROLLBACK	ROWS
SCHEMA	SCROLL	SECOND	SECTION
SELECT	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

COBSQL

COBSQL Error Messages