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


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