Reserved Words

The following keywords are reserved in Mimer SQL statements.

They must be enclosed in quotation marks if you want to use them as SQL identifiers.

ALL	ALLOCATE	ALTER
AND	ANY	AS
ASYMMETRIC	AT	ATOMIC
AUTHORIZATION	BEGIN	BETWEEN
BOTH	BY	CALL
CALLED	CASE	CAST
CHECK	CLOSE	COLLATE
COLUMN	COMMIT	CONDITION
CONNECT	CONSTRAINT	CORRESPONDING
CREATE	CROSS	CURRENT
CURRENT_DATE	CURRENT_PATH	CURRENT_TIME
CURRENT_TIMESTAMP	CURRENT_USER	CURSOR
DAY	DEALLOCATE	DECLARE
DEFAULT	DELETE	DESCRIBE
DETERMINISTIC	DISCONNECT	DISTINCT
DO	DROP	ELSE
ELSEIF	END	ESCAPE
EXCEPT	EXECUTE	EXISTS
EXTERNAL	FALSE	FETCH
FIRST ^a	FOR	FOREIGN
FROM	FULL	FUNCTION
GET	GLOBAL	GRANT
GROUP	HANDLER	HAVING
HOLD	HOUR	IDENTITY
IF	IN	INDICATOR
INNER	INOUT	INSERT
INTERSECT	INTERVAL	INTO
IS	ITERATE	JOIN
LANGUAGE	LARGE	LEADING
LEAVE	LEFT	LIKE
LOCAL	LOCALTIME	LOCALTIMESTAMP
LOOP	MATCH	MEMBER
METHOD	MINUTE	MODIFIES
MODULE	MONTH	NATIONAL
NATURAL	NEW	NEXT^a
NO	NOT	NULL
OF	OFFSET	OLD
ON	OPEN	OR
ORDER	OUT	OVERLAPS
PARAMETER	PRECISION	PREPARE
PRIMARY	PROCEDURE	READS
RECURSIVE	REFERENCES	REFERENCING
RELEASE	REPEAT	RESIGNAL
RESULT	RETURN	RETURNS
REVOKE	RIGHT	ROLLBACK
ROW	ROWS	SCROLL
SECOND	SELECT	SESSION_USER
SET	SIGNAL	SOME
SPECIFIC	SQL	SQLEXCEPTION
SQLSTATE	SQLWARNING	START
STATIC	SYMMETRIC	SYSTEM_USER
TABLE	THEN	TIMEZONE_HOUR
TIMEZONE_MINUTE	TO	TRAILING
TREAT	TRIGGER	TRUE
UNION	UNIQUE	UNKNOWN
UNTIL	UPDATE	USER
USING	VALUE	VALUES
VARYING	WHEN	WHERE
WHILE	WITH
WITHOUT	YEAR

^aListed as non-reserved in the SQL-2016 standard.

Note:The keyword END-EXEC is also reserved specifically in statements embedded in COBOL programs.

Reserved Keywords in the SQL Standard

The following keywords are reserved in the SQL-2016 standard, but not in Mimer SQL:

ABS	ABSENT	ACOS
ARE	ARRAY	ARRAY_AGG
ARRAY_MAX_ CARDINALITY	ASENSITIVE	ASIN
ATAN	AVG	BEGIN_FRAME
BEGIN_PARTITION	BIGINT	BINARY
BLOB	BOOLEAN	CARDINALITY
CASCADED	CEIL	CEILING
CHAR	CHAR_LENGTH	CHARACTER
CHARACTER_LENGTH	CLASSIFIER	CLOB
COALESCE	COLLECT	CONTAINS
CONVERT	COPY	CORR
COS	COSH	COUNT
COVAR_POP	COVAR_SAMP	CUBE
CUME_DIST	CURRENT_CATALOG	CURRENT_DEFAULT_ TRANSFORM_GROUP
CURRENT_ROLE	CURRENT_ROW	CURRENT_SCHEMA
CURRENT_TRANSFORM _GROUP_FOR_TYPE	CYCLE	DATE
DEC	DECIMAL	DECFLOAT
DEFINE	DENSE_RANK	DEREF
DOUBLE	DYNAMIC	EACH
ELEMENT	EMPTY	END_FRAME
END_PARTITION	END-EXEC	EQUALS
EVERY	EXEC	EXP
EXTRACT	FILTER	FIRST_VALUE
FLOAT	FLOOR	FRAME_ROW
FREE	FUSION	GROUPING
GROUPS	INITIAL	INSENSITIVE
INT	INTEGER	INTERSECTION
JSON	JSON_ARRAY	JSON_ARRAYAGG
JSON_EXISTS	JSON_OBJECT	JSON_OBJECTAGG
JSON_QUERY	JSON_TABLE	JSON_TABLE_ PRIMITIVE
JSON_VALUE	LAG	LAST_VALUE
LATERAL	LEAD	LIKE_REGEX
LISTAGG	LN	LOG
LOG10	LOWER	MATCH_NUMBER
MATCH_RECOGNIZE	MATCHES	MAX
MERGE	MIN	MOD
MULTISET	NCHAR	NCLOB
NONE	NORMALIZE	NTH_VALUE
NTILE	NULLIF	NUMERIC
OCTET_LENGTH	OCCURRENCES_REGEX	OMIT
ONE	ONLY	OUTER
OVER	OVERLAY	PARTITION
PATTERN	PER	PERCENT
PERCENT_RANK	PERCENTILE_CONT	PERCENTILE_DISC
PERIOD	PORTION	POSITION
POSITION_REGEX	POWER	PRECEDES
PTF	RANGE	RANK
REAL	REF	REGR_AVGX
REGR_AVGY	REGR_COUNT	REGR_INTERCEPT
REGR_R2	REGR_SLOPE	REGR_SXX
REGR_SXY	REGR_SYY	ROLLUP
ROW_NUMBER	RUNNING	SAVEPOINT
SCOPE	SEARCH	SEEK
SENSITIVE	SHOW	SIMILAR
SIN	SINH	SKIP
SMALLINT	SPECIFICTYPE	SQL
SQRT	STDDEV_POP	STDDEV_SAMP
SUBMULTISET	SUBSET	SUBSTRING
SUBSTRING_REGEX	SUCCEEDS	SUM
SYSTEM	SYSTEM_TIME	TABLESAMPLE
TAN	TANH	TIME
TIMESTAMP	TRANSLATE	TRANSLATE_REGEX
TRANSLATION	TRIM	TRIM_ARRAY
TRUNCATE	UESCAPE	UNNEST
UPPER	VALUE_OF	VAR_POP
VAR_SAMP	VARBINARY	VARCHAR
VERSIONING	WHENEVER	WIDTH_BUCKET
WINDOW	WITHIN