Reserved words

A number of words cannot be used as ordinary identifiers in some contexts because these words might be interpreted as SQL keywords.

For example, ALL cannot be a column name in a SELECT statement. Each word, however, can be a delimited identifier in contexts where the word otherwise cannot be an ordinary identifier. For example, the quotation mark (") is the escape character that begins and ends delimited identifiers. "ALL" can appear as a column name in a SELECT statement.

You must use the following words as delimited identifiers where referring to an SQL identifier or native identifier in any SQL statement:

ADD
ALL
ALTER
AND
ANY
AS
AUDIT
BETWEEN
BIND
BUFFERPOOL
BY
CALL
CAPTURE
CHAR
CHARACTER
CHECK
CLUSTER
COLLECTION
COLUMN
CONCAT
CONSTRAINT
COUNT
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURSOR
DATABASE
DAY
DAYS
DEFAULT
DELETE
DESCRIPTOR
DISTINCT
DOUBLE
DROP
EDITPROC
ERASE
ESCAPE
EXCEPT
EXECUTE
EXISTS
FIELDPROC
FOR
FROM
FULL
GO
GOTO
GRANT
GROUP
HAVING
HOUR
HOURS
IMMEDIATE
IN
INDEX
INNER
INOUT
INSERT
INTO
IS
JOIN
KEY
LEFT
LIKE
LOCKMAX
LOCKSIZE
MICROSECOND
MICROSECONDS
MINUTE
MINUTES
MONTH
MONTHS
NOT
NULL
NUMPARTS
OBID
OF
ON
OPTIMIZE
OR
ORDER
OUT
OUTER
PACKAGE
PART
PLAN
PRECISION
PRIQTY
PRIVILEGES
PROGRAM
REFERENCES
RIGHT
SECOND
SECONDS
SECQTY
SELECT
SET
SOME
STOGROUP
SUBPAGES
SYNONYM
TABLE
TABLESPACE
TO
UNION
UNIQUE
UPDATE
USER
USING
VALIDPROC
VALUES
VCAT
VIEW
VOLUMES
WHERE
WITH
YEAR
YEARS