Validation for Reserved Words

If you choose the Validate check box while creating a synonym reserved words are checked for. The following reserved words cannot be used as names in the created synonym:

Reserved Word

ALIAS, ALL, ALTER, AND, ANY, AS, ASC, AUTHORIZATION, AVG

BEGIN, BETWEEN, BINARY, BIT, BOTH, BY

CALL, CASE, CAST, CHAR, CHARACTER, CHECK, CLOSE, COALESCE, COLFETCH, COMMIT, CONCAT, CONNECT, CORRESPONDING, COUNT, CREATE, CROSS, CURRENT, CURSOR

DATABASE, DATE, DATETIME, DAY, DAYS, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DELETE, DESC, DISTINCT, DO, DOUBLE, DROP

ELSE, ELSEIF, END, ESCAPE, EXCEPT, EXECUTE, EXISTS, EXPLAIN

FETCH, FLOAT, FOR, FOREIGN, FROM, FULL, FUNCTION

GET, GRANT, GRAPHIC, GROUP

HAVING, HOUR, HOURS

IF, IMAGE, INCLUDE, IN, INDEX, INDICATOR, INNER, INOUT, INSERT, INT, INTEGER, INTERSECT, INTO, IS, ITERAT

JOIN

KEY

LEADING, LEAVE, LEFT, LIKE, LOCK, LOGICAL, LONG, LOOP

MAX, MICROSECOND, MICROSECONDS, MILLISECOND, MILLISECONDS, MIN, MINUTE, MINUTES, MONEY, MONTH, MONTHS

NATURAL, NOT, NULL, NULLIF, NUMBER, NUMERIC

OF, ON, ONLY, OPEN, OPTIMIZE, OPTION, OR, ORDER, OUT, OUTER

PACKAGE, PERCENT, PLAN, PRECISION, PREPARE, PRIMARY, PROCEDURE, PROGRAM, PURGE

QUERYNO

RAW, REAL, REFERENCES, REPEAT, RESET, RETURN, RETURNS, REVOKE, RIGHT, ROLLBACK, ROW, ROWS

SCHEMA, SECOND, SECONDS, SELECT, SERIAL, SET, SMALLFLOAT, SMALLINT, SOME, STOGROUP, SUM, SYNONYM, SYSNAME

TABLE, TABLESPACE, TEXT, THEN, TIME, TIMESTAMP, TO, TRAILING, TRUNCATE

UNION, UNIQUE, UNTIL, UPDATE, USER, USER_TYPE_NAME, USING

VALUES, VARBINARY, VARCHAR, VARGRAPHIC, VARYING, VIEW

WHEN, WHERE, WHILE, WITH, WORK

YEAR, YEARS


iWay Software