Reserved words
The following table contains the PL/MX reserved words. Reserved words cannot be used for identifiers in PL/MX unless they are in double-quotes.
ACTION | FOR | PUBLIC |
ADD | FOREIGN | READ |
ADMIN | FOUND | READS |
AFTER | FRACTION | REAL |
AGGREGATE | FREE | RECURSIVE |
ALIAS | FROM | REF |
ALL | FULL | REFERENCES |
ALLOCATE | FUNCTION | REFERENCING |
ALTER | GENERAL | RELATIVE |
AND | GET | REPLACE |
ANY | GLOBAL | RESIGNAL |
ARE | GO | RESOURCE |
ARRAY | GOTO | RESTRICT |
AS | GRANT | RESULT |
ASC | GROUP | RETURN |
ASSERTION | GROUPING | RETURNS |
ASYNC | HAVING | REVOKE |
AT | HOST | RIGHT |
AUTHORIZATION | HOUR | ROLE |
AVG | IDENTIFIED | ROLLBACK |
BEFORE | IDENTITY | ROLLUP |
BEGIN | IF | ROUTINE |
BETWEEN | IGNORE | ROW |
BINARY | IMMEDIATE | ROWS |
BIT | IN | SAVEPOINT |
BIT_LENGTH | INDEX | SCHEMA |
BLOB | INDEXES | SCOPE |
BOOLEAN | INDICATOR | SCROLL |
BOTH | INITIALLY | SEARCH |
BREADTH | INNER | SECOND |
BY | INOUT | SECTION |
CALL | INPUT | SELECT |
CASE | INSENSITIVE | SENSITIVE |
CASCADE | INSERT | SESSION |
CASCADED | INT | SESSION_USER |
CAST | INTEGER | SET |
CATALOG | INTERSECT | SETS |
CHAR | INTERVAL | SHARE |
CHAR_LENGTH | INTO | SIGNAL |
CHARACTER | IS | SIMILAR |
CHARACTER_LENGTH | ISOLATION | SIZE |
CHECK | ITERATE | SMALLINT |
CLASS | JOIN | SOME |
CLOB | KEY | SPECIFIC |
CLOSE | LANGUAGE | SPECIFICTYPE |
CLUSTER | LARGE | SQL |
CLUSTERS | LAST | SQL_CHAR |
COALESCE | LATERAL | SQL_DATE |
COLAUTH | LEADING | SQL_DECIMAL |
COLLATE | LEAVE | SQL_DOUBLE |
COLLATION | LEFT | SQL_FLOAT |
COLUMN | LESS | SQL_INT |
COLUMNS | LEVEL | SQL_INTEGER |
COMMIT | LIKE | SQL_REAL |
COMPLETION | LIMIT | SQL_SMALLINT |
COMPRESS | LOCAL | SQL_TIME |
CONNECT | LOCALTIME | SQL_TIMESTAMP |
CONNECTION | LOCALTIMESTAMP | SQL_VARCHAR |
CONSTRAINT | LOCATOR | SQLCODE |
CONSTRAINTS | LOCK | SQLERROR |
CONSTRUCTOR | LOOP | SQLEXCEPTION |
CONTINUE | LOWER | SQLSTATE |
CONVERT | MAP | SQLWARNING |
CORRESPONDING | MATCH | START |
COUNT | MAX | STRUCTURE |
CRASH | MIN | SUBSTRING |
CREATE | MINUS | SUBTYPE |
CROSS | MINUTE | SUM |
CUBE | MODE | SYSTEM_USER |
CURRENT | MODIFIES | TABAUTH |
CURRENT_DATE | MODIFY | TABLE |
CURRENT_PATH | MODULE | TEMPORARY |
CURRENT_ROLE | MONTH | TERMINATE |
CURRENT_TIME | NAMES | TEST |
CURRENT_TIMESTAMP | NATIONAL | THAN |
CURRENT_USER | NATURAL | THEN |
CURRVAL | NCHAR | THERE |
CURSOR | NCLOB | TIME |
CYCLE | NEW | TIMESTAMP |
DATE | NEXT | TIMEZONE_HOUR |
DATETIME | NEXTVAL | TIMEZONE_MINUTE |
DAY | NO | TO |
DEALLOCATE | NOCOMPRESS | TRAILING |
DEC | NONE | TRANSACTION |
DECIMAL | NOT | TRANSLATE |
DECLARE | NOWAIT | TRANSLATION |
DEFAULT | NULL | TRANSPOSE |
DEFERRABLE | NULLIF | TREAT |
DEFERRED | NUMERIC | TRIGGER |
DELETE | OBJECT | TRIM |
DEPTH | OCTET_LENGTH | TRUE |
DEREF | OF | TYPE |
DESC | OFF | UNDER |
DESCRIBE | OID | UNION |
DESCRIPTOR | OLD | UNIQUE |
DESTROY | ON | UNKNOWN |
DESTRUCTOR | ONLY | UNNEST |
DETERMINISTIC | OPEN | UPDATE |
DIAGNOSTICS | OPERATORS | UPPER |
DISTINCT | OPTION | UPSHIFT |
DICTIONARY | OR | USAGE |
DISCONNECT | ORDER | USER |
DOMAIN | ORDINALITY | USING |
DOUBLE | OTHERS | VALUE |
DROP | OUT | VALUES |
DYNAMIC | OUTER | VARCHAR |
EACH | OUTPUT | VARIABLE |
ELSE | OVERLAPS | VARYING |
ELSEIF | PAD | VIEW |
ELSIF | PARAMETER | VIEWS |
END | PARAMETERS | VIRTUAL |
ENDIS | PARTIAL | VISIBLE |
END-EXEC | PENDANT | WAIT |
EQUALS | POSITION | WHEN |
ESCAPE | POSTFIX | WHENEVER |
EXCEPT | PRECISION | WHERE |
EXCEPTION | PREFIX | WHILE |
EXEC | PREORDER | WITH |
EXCLUSIVE | PREPARE | WITHOUT |
EXECUTE | PRESERVE | WORK |
EXISTS | PRIMARY | WRITE |
EXTERNAL | PRIOR | YEAR |
EXTRACT | PRIVATE | ZONE |
FALSE | PRIVILEGES | |
FETCH | PROCEDURE | |
FIRST | PROTECTED | |
FLOAT | PROTOTYPE |