Appendix C: Reserved Words

The following words cannot be used for the names of tracking services, message definitions, or message definition columns.

Message definitions have restrictions on their names and the names of their columns to allow Tracking Server to consistently support logging to SQL-compliant databases and to publish their messages on messaging systems.

These words are not case sensitive. For example, not only is ABSOLUTE restricted, but also absolute, Absolute, or ABsoLUte.

The list of reserved words may change over time.

List of Reserved Words

ABSOLUTE	FLOAT	PRIMARY
ACTION	FOR	PRIOR
ADA	FOREIGN	PRIVATE
ADD	FORTRAN	PRIVILEGES
ADMIN	FOUND	PROCEDURE
AFTER	FREE	PROTECTED
AGGREGATE	FROM	PUBLIC
ALIAS	FULL	READ
ALL	FUNCTION	READS
ALLOCATE	GENERAL	REAL
ALTER	GET	RECURSIVE
AND	GLOBAL	REF
ANY	GO	REFERENCES
ARE	GOTO	REFERENCING
ARRAY	GRANT	RELATIVE
AS	GROUPING	REPLACE
ASC	HAVING	RESIGNAL
ASSERTION	HOST	RESTRICT
ASYNC	HOUR	RESULT
AT	IDENTITY	RETURN
AUTHORIZATION	IF	RETURNS
AVG	IGNORE	REVOKE
BEFORE	IMMEDIATE	RIGHT
BEGIN	IN	ROLE
BETWEEN	INCLUDE	ROLLBACK
BINARY	INDICATOR	ROLLUP
BIT	INITIALIZE	ROUTINE
BIT_LENGTH	INNER	ROW
BLOB	INOUT	ROWS
BOOLEAN	INPUT	RULE
BOTH	INSENSITIVE	SAVEPOINT
BREADTH	INSERT	SCHEMA
BY	INTEGER	SCOPE
CALL	INTERSECT	SCROLL
CASCADE	INTERVAL	SEARCH
CASCADED	INTO	SECOND
CASE	ISOLATION	SECTION
CAST	ITERATE	SELECT
CATALOG	JOIN	SENSITIVE
CHAR	KEY	SESSION
CHAR_LENGTH	LANGUAGE	SESSION_USER
CHECK	LARGE	SET
CLASS	LAST	SETS
CLOB	LATERAL	SIGNAL
CLOSE	LEADING	SIMILAR
COALESCE	LEAVE	SIZE
COBOL	LEFT	SMALLINT
COLLATE	LESS	SOME
COLLATION	LEVEL	SPACE
COLUMN	LIKE	SPECIFIC
COMMIT	LIMIT	SPECIFICTYPE
COMPLETION	LOCAL	SQL
CONNECT	LOCALTIME	SQLCA
CONNECTION	LOCALTIMESTAMP	SQLCODE
CONSTRAINT	LOCATOR	SQLERROR
CONSTRUCTOR	LOOP	SQLEXCEPTION
CONTINUE	LOWER	SQLSTATE
CONVERT	MAP	SQLWARNING
CORRESPONDING	MATCH	START
COUNT	MAX	STATE
CREATE	MIN	STATEMENT
CROSS	MINUTE	STATIC
CUBE	MODIFIES	STRUCTURE
CURRENT	MODIFY	SUBSTRING
CURRENT_DATE	MODULE	SUM
CURRENT_JPATH	MONTH	SYSTEM
CURRENT_ROLE	MUMPS	SYSTEM_USER
CURRENT_TIME	NAMES	TABLE
CURRENT_TIMESTAMP	NATIONAL	TEMPORARY
CURRENT_USER	NATURAL	TERMINATE
CURSOR	NCHAR	TEST
CYCLE	NCLOB	THAN
DATA	NEW	THEN
DATE	NEXT	THERE
DAY	NO	TIME
DEALLOCATE	NONE	TIMESTAMP
DEC	NOT	TIMEZONE_HOUR
DECIMAL	NULL	TIMEZONE_MINUTE
DECLARE	NULLIF	TO
DEFAULT	NUMERIC	TRAILING
DEFERRABLE	OBJECT	TRANSACTION
DEFERRED	OCTET_LENGTH	TRANSLATION
DELETE	OF	TREAT
DEPTH	OFF	TRIGGER
DEREF	OID	TRUE
DESC	OLD	TYPE
DESCRIBE	ON	UNDER
DESCRIPTOR	ONLY	UNION
DESTROY	OPEN	UNIQUE
DESTRUCTOR	OPERATION	UNKNOWN
DETERMINISTIC	OPERATORS	UNNEST
DIAGNOSTICS	OPTION	UPDATE
DICTIONARY	OR	UPPER
DISTINCT	ORDER	USAGE
DOMAIN	ORDINALITY	USER
DOUBLE	OTHERS	USING
DROP	OUT	VALUE
DYNAMIC	OUTER	VALUES
EACH	OUTPUT	VARCHAR
ELSE	OVERLAPS	VARIABLE
ELSEIF	PAD	VARYING
END	PARAMETER	VIEW
END-EXEC	PARAMETERS	VIRTUAL
EQUALS	PARTIAL	VISIBLE
ESCAPE	PASCAL	WAIT
EVERY	PATH	WHEN
EXCEPT	PENDANT	WHENEVER
EXCEPTION	PLI	WHERE
EXEC	POSITION	WHILE
EXECUTE	POSTFIX	WITH
EXISTS	PRECISION	WITHOUT
EXTERNAL	PREFIX	WORK
FALSE	PREORDER	WRITE
FETCH	PREPARE	YEAR
FIRST	PRESERVE	ZONE