Keywords
All keywords reserved by the SQL 92 and SQL 99 standards are reserved in the Open SQL grammar. You cannot use reserved keywords for column or table names.

Tables not created with the
Table Editor may
have column or table names conflicting with an Open SQL keyword. To access
such tables or columns, you use delimited
identifiers.
Keywords reserved by Open SQL
ABSOLUTE, ACTION, ACTOR, ADD, AFTER, ALIAS,ALL, ALLOCATE, ALTER, AND, ANY, ARE, AS, ASC, ASSERTION, ASYNC, AT, ATTRIBUTES, AUTHORIZATION, AVG, BEFORE, BEGIN, BETWEEN, BIT, BIT_LENGTH, BOOLEAN, BOTH, BREADTH, BY, CASCADE, CASCADED, CASE, CAST, CATALOG, CHAR, CHAR_LENGTH, CHARACTER, CHARACTER_LENGTH, CHECK, CLASS, CLOSE, COALESCE, COLLATE, COLLATION, COLUMN, COMMIT, COMPLETION, CONNECT, CONNECTION, CONSTRAINT, CONSTRAINTS, CONSTRUCTOR, CONTINUE, CONVERT, CORRESPONDING, COUNT, CREATE, CROSS, CURRENT, CURRENT_DATE, CURRENT_PATH, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR, CYCLE, DATA, DATE, DAY, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DEFERRABLE, DEFERRED, DELETE, DEPTH, DESC, DESCRIBE, DESCRIPTOR, DESIGNATOR, DESTROY, DESTRUCTOR, DIAGNOSTICS, DICTIONARY, DISCONNECT, DISTINCT, DOMAIN, DOUBLE, DROP, EACH, ELEMENT, ELSE, END, END-EXEC, EQUALS, ESCAPE, EXCEPT, EXCEPTION, EXEC, EXECUTE, EXISTS, EXTERNAL, EXTRACT, FACTOR, FALSE, FETCH, FIRST, FLOAT, FOR, FOREIGN, FOUND, FROM, FULL, FUNCTION, GENERAL, GET, GLOBAL, GO, GOTO, GRANT, GROUP, HAVING, HOUR, IDENTITY, IGNORE, IMMEDIATE, IN, INDICATOR, INITIALLY, INNER, INOUT, INPUT, INSENSITIVE, INSERT, INSTEAD, INT, INTEGER, INTERSECT, INTERVAL, INTO, IS, ISOLATION, JOIN, KEY, LANGUAGE, LAST, LEADING, LEFT, LESS, LEVEL, LIKE, LIMIT, LIST, LOCAL, LOWER, MATCH, MAX, MIN, MINUTE, MODIFY, MODULE, MONTH, MOVE, MULTISET, NAMES, NATIONAL, NATURAL, NCHAR, NEW, NEW_TABLE, NEXT, NO, NONE, NOT, NULL, NULLIF, NUMERIC, OCTET_LENGTH, OF, OFF, OID, OLD, OLD_TABLE, ON, ONLY, OPEN, OPERATION, OPERATOR, OPERATORS, OPTION, OR, ORDER, OUT, OUTER, OUTPUT, OVERLAPS, PAD, PARAMETERS, PARTIAL, PATH, PENDANT, POSITION, POSTFIX, PRECISION, PREFIX, PREORDER, PREPARE, PRESERVE, PRIMARY, PRIOR, PRIVATE, PRIVILEGES, PROCEDURE, PROTECTED, PUBLIC, READ, REAL, RECURSIVE, REFERENCES, REFERENCING, RELATIVE, REPRESENTATION, RESTRICT, REVOKE, RIGHT, ROLE, ROLLBACK, ROUTINE, ROW, ROWS, SAVEPOINT, SCHEMA, SCROLL, SEARCH, SECOND, SECTION, SELECT, SENSITIVE, SEQUENCE, SESSION, SESSION_USER, SET, SIMILAR, SIZE, SMALLINT, SOME, SPACE, SPECIFIC, SQL, SQLCODE, SQLERROR, SQLEXCEPTION, SQLSTATE, SQLWARNING, START, STATE, STRUCTURE, SUBSTRING, SUM, SYMBOL, SYSTEM_USER, TABLE, TEMPLATE, TEMPORARY, TERM, TEST, THAN, THEN, THERE, TIME, TIMESTAMP, TIMEZONE_HOUR, TIMEZONE_MINUTE, TO, TRAILING, TRANSACTION, TRANSLATE, TRANSLATION, TRIGGER, TRIM, TRUE, TYPE, UNDER, UNION, UNIQUE, UNKNOWN, UPDATE, UPPER, USAGE, USER, USING, VALUE, VALUES, VARCHAR, VARIABLE, VARIANT, VARYING, VIEW, VIRTUAL, VISIBLE, WAIT, WHEN, WHENEVER, WHERE, WITH, WITHOUT, WORK, WRITE, YEAR, ZONE |