Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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
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
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 the SQL Standard

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

ARE
ARRAY
ASENSITIVE
BIGINT
BINARY
BLOB
BOOLEAN
CASCADED
CHAR
CHARACTER
CLOB
CUBE
CURRENT_CATALOG
CURRENT_DEFAULT_
TRANSFORM_GROUP
CURRENT_ROLE
CURRENT_SCHEMA
CURRENT_TRANSFORM
_GROUP_FOR_TYPE
CYCLE
DATE
DEC
DECIMAL
DEREF
DOUBLE
DYNAMIC
EACH
ELEMENT
EXEC
FILTER
FLOAT
FREE
GROUPING
INSENSITIVE
INT
INTEGER
LATERAL
MERGE
MULTISET
NCHAR
NCLOB
NONE
NUMERIC
ONLY
OUTER
OVER
PARTITION
RANGE
REAL
RECURSIVE
REF
ROLLUP
SAVEPOINT
SCOPE
SEARCH
SENSITIVE
SIMILAR
SMALLINT
SPECIFICTYPE
SUBMULTISET
SYSTEM
TABLESAMPLE
TIME
TIMESTAMP
TRANSLATION
TREAT
TRUNCATE
UESCAPE
UNNEST
VARBINARY
VARCHAR
WHENEVER
WINDOW
WITHIN


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX