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

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

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

 

 

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

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_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