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
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40