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
ARE
AS
AT
AUTHORIZATION
BEGIN
BETWEEN
BOTH
BY
CALL
CASCADED
CASE
CAST
CHARACTER
CHECK
CLOSE
COLLATE
COLUMN
COMMIT
CONNECT
CONSTRAINT
CORRESPONDING
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_PATH
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
DAY
DEALLOCATE
DECLARE
DEFAULT
DELETE
DESCRIBE
DISCONNECT
DISTINCT
DO
DROP
EACH
ELSE
ELSEIF
END
EXCEPT
EXECUTE
EXISTS
FALSE
FETCH
FOR
FOREIGN
FROM
FULL
FUNCTION
GET
GLOBAL
GRANT
GROUP
HAVING
HOLD
HOUR
IDENTITY
IF
IN
INDICATOR
INNER
INOUT
INSERT
INTERSECT
INTERVAL
INTO
IS
JOIN
LARGE
LEADING
LEAVE
LEFT
LIKE
LOCAL
LOCALTIME
LOCALTIMESTAMP
LOOP
MATCH
MINUTE
MODULE
MONTH
NATIONAL
NATURAL
NEW
NOT
NULL
OF
OLD
ON
ONLY
OPEN
OR
ORDER
OUT
OUTER
OVERLAPS
PRECISION
PREPARE
PRIMARY
PROCEDURE
REFERENCES
REFERENCING
RELEASE
REPEAT
RESIGNAL
RETURN
REVOKE
RIGHT
ROLLBACK
ROW
SECOND
SELECT
SESSION_USER
SET
SIGNAL
SOME
SPECIFIC
SQLEXCEPTION
SQLSTATE
SQLWARNING
START
SYSTEM_USER
TABLE
THEN
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TRAILING
TRANSLATION
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-99

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

ABS
ABSOLUTE
ACTION
ADD
AFTER
ARRAY
ASC
ASENSITIVE
ASSERTION
ASYMMETRIC
ATOMIC
AVG
BEFORE
BINARY
BIT
BIT_LENGTH
BLOB
BOOLEAN
BREADTH
CALLED
CARDINALITY
CASCADE
CATALOG
CHAR
CHAR_LENGTH
CHARACTER_LENGTH
CLOB
COALESCE
COLLATION
CONDITION
CONNECTION
CONSTRAINTS
CONSTRUCTOR
CONTAINS
CONTINUE
CONVERT
COUNT
CUBE
CURRENT_ROLE
CYCLE
DATA
DATE
DEC
DECIMAL
DEFERRABLE
DEFERRED
DEPTH
DEREF
DESC
DESCRIPTOR
DETERMINISTIC
DIAGNOSTICS
DOMAIN
DOUBLE
DYNAMIC
EQUALS
ESCAPE
EVERY
EXCEPTION
EXEC
EXIT
EXTERNAL
EXTRACT
FIRST
FLOAT
FOUND
FREE
GENERAL
GO
GOTO
GROUPING
HANDLER
IMMEDIATE
INITIALLY
INPUT
INSENSITIVE
INT
INTEGER
ISOLATION
ITERATE
KEY
LANGUAGE
LAST
LATERAL
LEVEL
LOCATOR
LOWER
MAP
MAX
METHOD
MIN
MOD
MODIFIES
NAMES
NCHAR
NCLOB
NEXT
NO
NONE
NULLIF
NUMERIC
OBJECT
OCTET_LENGTH
OPTION
ORDINALITY
OUTPUT
OVERLAY
PAD
PARAMETER
PARTIAL
PATH
POSITION
PRESERVE
PRIOR
PRIVILEGES
PUBLIC
READ
READS
REAL
RECURSIVE
REF
RELATIVE
RESTRICT
RESULT
RETURNS
ROLE
ROLLUP
ROUTINE
ROWS
SAVEPOINT
SCHEMA
SCOPE
SCROLL
SEARCH
SECTION
SENSITIVE
SESSION
SETS
SIMILAR
SIZE
SMALLINT
SPACE
SPECIFICTYPE
SQL
SUBSTRING
SUM
SYMMETRIC
SYSTEM
TEMPORARY
TIME
TIMESTAMP
TRANSACTION
TRANSLATE
TREAT
TRIM
UNDER
UNDO
UNNEST
UPPER
USAGE
VARCHAR
WHENEVER
VIEW
WORK
WRITE
ZONE



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