Reserved Words
The following keywords are reserved in Mimer SQL statements.
They must be enclosed in quotation marks if they are to be used 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 SQL99 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 SQL92 and SQL/PSM
The following keywords are reserved in SQL92 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 |
|
