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
|
AT
|
ATOMIC
|
| AUTHORIZATION
|
BEGIN
|
BETWEEN
|
BOTH
|
| BY
|
CALL
|
CASE
|
CAST
|
| CHARACTER
|
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
|
FALSE
|
FETCH
|
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
|
| METHOD
|
MINUTE
|
MODIFIES
|
MODULE
|
| MONTH
|
NATIONAL
|
NATURAL
|
NEW
|
| NO
|
NOT
|
NULL
|
OF
|
| OLD
|
ON
|
OPEN
|
OR
|
| ORDER
|
OUT
|
OVERLAPS
|
PRECISION
|
| PREPARE
|
PRIMARY
|
PROCEDURE
|
READS
|
| REFERENCES
|
REFERENCING
|
RELEASE
|
REPEAT
|
| RESIGNAL
|
RESULT
|
RETURN
|
RETURNS
|
| REVOKE
|
RIGHT
|
ROLLBACK
|
ROW
|
| SCROLL
|
SECOND
|
SELECT
|
SESSION_USER
|
| SET
|
SIGNAL
|
SOME
|
SPECIFIC
|
| SQL
|
SQLEXCEPTION
|
SQLSTATE
|
SQLWARNING
|
| START
|
STATIC
|
SYSTEM_USER
|
TABLE
|
| THEN
|
TIMEZONE_HOUR
|
TIMEZONE_MINUTE
|
TO
|
| TRAILING
|
TRIGGER
|
TRUE
|
UNION
|
| UNIQUE
|
UNKNOWN
|
UNTIL
|
UPDATE
|
| USER
|
USING
|
VALUE
|
VALUES
|
| VARYING
|
WHEN
|
WHERE
|
WHILE
|
| WITH
|
WITHOUT
|
YEAR
|
|
Note: The keyword END-EXEC is reserved specifically in statements embedded in COBOL programs.
An identifier in Mimer SQL can be protected against conflicting with potential reserved words by including a digit or an underscore in the identifier and by ensuring that it does not begin with CURRENT_, SESSION_, SYSTEM_ or TIMEZONE_.
Reserved Keywords in SQL-2003
The following keywords are reserved in SQL-2003, but not in Mimer SQL:
| ARE
|
ARRAY
|
ASENSITIVE
|
ASYMMETRIC
|
| BIGINT
|
BINARY
|
BLOB
|
BOOLEAN
|
| CALLED
|
CASCADED
|
CHAR
|
CLOB
|
| CUBE
|
CURRENT_DEFAULT_
TRANSFORM_GROUP
|
CURRENT_ROLE
|
CURRENT_TRANSFORM
_GROUP_FOR_TYPE
|
| CYCLE
|
DATE
|
DEC
|
DECIMAL
|
| DEREF
|
DOUBLE
|
DYNAMIC
|
EACH
|
| ELEMENT
|
EXEC
|
EXTERNAL
|
FILTER
|
| FLOAT
|
FREE
|
GROUPING
|
INSENSITIVE
|
| INT
|
INTEGER
|
LATERAL
|
MEMBER
|
| MERGE
|
MULTISET
|
NCHAR
|
NCLOB
|
| NONE
|
NUMERIC
|
ONLY
|
OUTER
|
| OVER
|
OVERLAY
|
PARAMETER
|
PARTITION
|
| RANGE
|
REAL
|
RECURSIVE
|
REF
|
| ROLLUP
|
ROWS
|
SAVEPOINT
|
SCOPE
|
| SEARCH
|
SENSITIVE
|
SIMILAR
|
SMALLINT
|
| SPECIFICTYPE
|
SUBMULTISET
|
SYMMETRIC
|
SYSTEM
|
| TABLESAMPLE
|
TIME
|
TIMESTAMP
|
TRANSLATE
|
| TRANSLATION
|
TREAT
|
UESCAPE
|
UNNEST
|
| VARCHAR
|
WHENEVER
|
WINDOW
|
WITHIN
|
