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