Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


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

DEFAULT
LARGE
ROLLBACK

DELETE
LEADING
ROW

Note: The keywords marked with became reserved in the SQL-99 standard. In addition, the keyword END-EXEC is reserved specifically in statements embedded in COBOL programs.

Potential Reserved Words

To avoid keywords that may become reserved in future versions of Mimer SQL, the following list of potential reserved words should be noted:

ARRAY
FREE
REF
SPECIFICTYPE
ASYMMETRIC
GROUPING
ROLLUP
SYMMETRIC
CUBE
ITERATE
SAVEPOINT
TREAT
CURRENT_ROLE
LATERAL
SCOPE
UNNEST
CYCLE
METHOD
SEARCH

DEREF
NONE
SIMILAR

There is no guarantee, however, that all of these keywords will, in fact, become reserved words in a future version of Mimer SQL and it is also almost certain that additional words will be added to the list as future versions emerge.

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-92 and SQL/PSM

The following keywords are reserved in SQL-92 and SQL/PSM, but not in Mimer SQL.

ABSOLUTE
DESCRIPTOR
LOWER
SCHEMA
ACTION
DETERMINISTIC
MAX
SCROLL
ADD
DIAGNOSTICS
MIN
SECTION
ASC
DOMAIN
NAMES
SESSION
ASSERTION
DOUBLE
NCHAR
SIZE
AVG
ESCAPE
NEXT
SMALLINT
BIT
EXCEPTION
NO
SPACE
BIT_LENGTH
EXEC
NULLIF
SQL
CASCADE
EXIT
NUMERIC
SQLCODE
CATALOG
EXTERNAL
OCTET_LENGTH
SQLERROR
CHAR
EXTRACT
OPTION
SUBSTRING
CHAR_LENGTH
FIRST
OUTPUT
SUM
CHARACTER_LENGTH
FLOAT
PAD
TEMPORARY
COALESCE
FOUND
PARTIAL
TIME
COLLATION
GO
PARAMETER
TIMESTAMP
CONDITION
GOTO
PATH
TRANSACTION
CONNECTION
HANDLER
POSITION
TRANSLATE
CONSTRAINTS
IMMEDIATE
PRESERVE
TRIM
CONTAINS
INITIALLY
PRIOR
UNDO
CONTINUE
INPUT
PRIVILEGES
UPPER
CONVERT
INSENSITIVE
PUBLIC
USAGE
COUNT
INT
READ
VARCHAR
DATE
INTEGER
REAL
VIEW
DEC
ISOLATION
RELATIVE
WHENEVER
DECIMAL
KEY
RESTRICT
WORK
DEFERRABLE
LANGUAGE
RETURNS
WRITE
DEFERRED
LAST
ROWS
ZONE
DESC
LEVEL
ROUTINE



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX