Reserved words

This is the list of currently reserved DB2® for i words.

Start of changeWords may be added at any time. For a list of additional words that may become reserved in the future, see the IBM® SQL and ANSI reserved words in the SQL Reference for Cross-Platform Development (http://www.ibm.com/developerworks/data/library/techarticle/0206sqlref/0206sqlref.html).End of change

Table 1. SQL Reserved Words

Start of changeACCORDINGEnd of change
Start of changeACCTNGEnd of change
ACTION
ACTIVATE
ADD
ALIAS
ALL
ALLOCATE
ALLOW
ALTER
AND
ANY
APPEND
Start of changeAPPLNAMEEnd of change
Start of changeARRAYEnd of change
Start of changeARRAY_AGGEnd of change
AS
ASC
ASENSITIVE
Start of changeASSOCIATEEnd of change
AT
Start of changeATOMICEnd of change
ATTRIBUTES
AUTHORIZATION
Start of changeBEFOREEnd of change
BEGIN
BETWEEN
BINARY
BIND
BIT
BUFFERPOOL
BY
CACHE
CALL
CALLED
CARDINALITY
CASE
CAST
CCSID
CHAR
CHARACTER
CHECK
Start of changeCLEnd of change
CLOSE
CLUSTER
COLLECT
COLLECTION
COLUMN
COMMENT

COMMIT
COMPACT
COMPRESS
CONCAT
Start of changeCONCURRENTEnd of change
CONDITION
CONNECT
CONNECTION
CONSTRAINT
CONTAINS
Start of changeCONTENTEnd of change
CONTINUE
COPY
COUNT
COUNT_BIG
CREATE
CROSS
CUBE
CURRENT
CURRENT_DATE
CURRENT_PATH
CURRENT_SCHEMA
CURRENT_SERVER
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TIMEZONE
CURRENT_USER
CURSOR
CYCLE
DATA
DATABASE
DATAPARTITIONNAME
DATAPARTITIONNUM
DATE
DAY
DAYS
DBINFO
DBPARTITIONNAME
DBPARTITIONNUM
DB2GENERAL
DB2GENRL
DB2SQL
DEACTIVATE
DEALLOCATE
DECLARE
DEFAULT
DEFAULTS
DEFER
DEFINE

DEFINITION
DELETE
DENSERANK
DENSE_RANK
DESC
DESCRIBE
DESCRIPTOR
DETERMINISTIC
DIAGNOSTICS
DISABLE
DISALLOW
DISCONNECT
DISTINCT
DO
Start of changeDOCUMENTEnd of change
DOUBLE
DROP
DYNAMIC
EACH
ELSE
ELSEIF
ENABLE
ENCRYPTION
END
ENDING
END-EXEC (COBOL only)
ENFORCED
ESCAPE
EVERY
EXCEPT
EXCEPTION
EXCLUDING
EXCLUSIVE
EXECUTE
EXISTS
EXIT
EXTEND
EXTERNAL
EXTRACT
FENCED
FETCH
Start of changeFIELDPROCEnd of change
FILE
FINAL
FOR
FOREIGN
FREE
FREEPAGE
FROM

FULL
FUNCTION
GBPCACHE
GENERAL
GENERATED
GET
GLOBAL
GO
GOTO
GRANT
GRAPHIC
GROUP
HANDLER
HASH
HASHED_VALUE
HAVING
HINT
HOLD
HOUR
HOURS
Start of changeIDEnd of change
IDENTITY
IF
Start of changeIGNOREEnd of change
IMMEDIATE
IMPLICITLY
IN
INCLUDE
INCLUDING
INCLUSIVE
INCREMENT
INDEX
INDEXBP
INDICATOR
INF
INFINITY
INHERIT
INNER
INOUT
INSENSITIVE
INSERT
INTEGRITY
INTERSECT
INTO
IS
ISOLATION
ITERATE
JAVA
JOIN

Table 2. SQL Reserved Words (continued)

KEY
LABEL
LANGUAGE
LATERAL
LEAVE
LEFT
LEVEL2
LIKE
LINKTYPE
LOCAL
LOCALDATE
LOCALTIME
LOCALTIMESTAMP
Start of changeLOCATIONEnd of change
Start of changeLOCATOREnd of change
LOCK
LOCKSIZE
LOG
LOGGED
LONG
LOOP
MAINTAINED
Start of changeMATCHEDEnd of change
MATERIALIZED
MAXVALUE
Start of changeMERGEEnd of change
MICROSECOND
MICROSECONDS
MINPCTUSED
MINUTE
MINUTES
MINVALUE
MIXED
MODE
MODIFIES
MONTH
MONTHS
Start of changeNAMESPACEEnd of change
NAN
NATIONAL
NCHAR
NCLOB
NEW
NEW_TABLE
NEXTVAL
NO
NOCACHE
NOCYCLE
NODENAME
NODENUMBER
NOMAXVALUE
NOMINVALUE
NONE
NOORDER
NORMALIZED
NOT
NULL

NULLS
NVARCHAR
OBID
OF
OLD
OLD_TABLE
ON
OPEN
OPTIMIZE
OPTION
OR
ORDER
Start of changeORDINALITYEnd of change
ORGANIZE
OUT
OUTER
OVER
OVERRIDING
PACKAGE
PADDED
PAGE
PAGESIZE
PARAMETER
PART
PARTITION
PARTITIONED
PARTITIONING
PARTITIONS
PASSWORD
PATH
PCTFREE
PIECESIZE
PLAN
POSITION
PREPARE
PREVVAL
PRIMARY
PRIQTY
PRIVILEGES
PROCEDURE
PROGRAM
Start of changePROGRAMIDEnd of change
QUERY
RANGE
RANK
RCDFMT
READ
READS
RECOVERY
REFERENCES
REFERENCING
REFRESH
RELEASE
RENAME
REPEAT
RESET
RESIGNAL

RESTART
RESULT
Start of changeRESULT_SET_LOCATOREnd of change
RETURN
RETURNS
REVOKE
RID
RIGHT
ROLLBACK
ROLLUP
ROUTINE
ROW
ROWNUMBER
ROW_NUMBER
ROWS
RRN
RUN
SAVEPOINT
SBCS
SCHEMA
SCRATCHPAD
SCROLL
SEARCH
SECOND
SECONDS
SECQTY
SELECT
SENSITIVE
SEQUENCE
SESSION
SESSION_USER
SET
SIGNAL
SIMPLE
SKIP
SNAN
SOME
SOURCE
SPECIFIC
SQL
SQLID
STACKED
START
STARTING
STATEMENT
STATIC
STOGROUP
SUBSTRING
SUMMARY
SYNONYM
SYSTEM_USER
TABLE
TABLESPACE
TABLESPACES
THEN
TIME
TIMESTAMP

TO
TRANSACTION
TRIGGER
TRIM
Start of changeTRIM_ARRAYEnd of change
TYPE
UNDO
UNION
UNIQUE
Start of changeUNITEnd of change
Start of changeUNNESTEnd of change
UNTIL
UPDATE
Start of changeURIEnd of change
USAGE
Start of changeUSEEnd of change
USER
Start of changeUSERIDEnd of change
USING
VALUE
VALUES
VARIABLE
VARIANT
VCAT
VERSION
VIEW
VOLATILE
Start of changeWAITEnd of change
WHEN
Start of changeWHENEVEREnd of change
WHERE
WHILE
WITH
WITHOUT
WRITE
Start of changeWRKSTNNAMEEnd of change
Start of changeXMLAGGEnd of change
Start of changeXMLATTRIBUTESEnd of change
Start of changeXMLCASTEnd of change
Start of changeXMLCOMMENTEnd of change
Start of changeXMLCONCATEnd of change
Start of changeXMLDOCUMENTEnd of change
Start of changeXMLELEMENTEnd of change
Start of changeXMLFORESTEnd of change
Start of changeXMLGROUPEnd of change
Start of changeXMLNAMESPACESEnd of change
Start of changeXMLPARSEEnd of change
Start of changeXMLPIEnd of change
Start of changeXMLROWEnd of change
Start of changeXMLSERIALIZEEnd of change
Start of changeXMLTEXTEnd of change
Start of changeXMLVALIDATEEnd of change
Start of changeXSLTRANSFORMEnd of change
Start of changeXSROBJECTEnd of change
YEAR
YEARS
YES