Reserved words

This is the list of currently reserved Db2 for i words.

Words 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 page.

Table 1. SQL Reserved Words

ABSENT

CREATE

DEFINITION

ACCORDING

CACHE

CREATEIN

DELETE

ACCTNG

CALL

CROSS

DELETING

ACTION

CALLED

CUBE

DENSERANK

ACTIVATE

CARDINALITY

CUME_DIST

DENSE_RANK

ADD

CASE

CURRENT

DESC

ALIAS

CAST

CURRENT_DATE

DESCRIBE

ALL

CCSID

CURRENT_PATH

DESCRIPTOR

ALLOCATE

CHAR

CURRENT_SCHEMA

DETACH

ALLOW

CHARACTER

CURRENT_SERVER

DETERMINISTIC

ALTER

CHECK

CURRENT_TIME

DIAGNOSTICS

AND

CURRENT_TIMESTAMP

DISABLE

ANY

CURRENT_TIMEZONE

DISALLOW

APPEND

CLUSTER

CURRENT_USER

DISCONNECT

APPLNAME

COLLECT

CURSOR

DISTINCT

ARRAY

COLLECTION

CYCLE

ARRAY_AGG

COLUMN

DATA

DOCUMENT

ARRAY_TRIM

COMMENT

DATABASE

DOUBLE

COMMIT

DATAPARTITIONNAME

DROP

ASC

COMPACT

DATAPARTITIONNUM

DYNAMIC

ASENSITIVE

COMPARISONS

DATE

EACH

ASSOCIATE

COMPRESS

DAY

ELSE

ATOMIC

CONCAT

DAYS

ELSEIF

ATTACH

CONCURRENT

DBINFO

EMPTY

ATTRIBUTES

CONDITION

DBPARTITIONNAME

ENABLE

AUTHORIZATION

CONNECT

DBPARTITIONNUM

ENCODING

AUTONOMOUS

CONNECT_BY_ROOT

DB2GENERAL

ENCRYPTION

BEFORE

CONNECTION

DB2GENRL

END

BEGIN

CONSTANT

DB2SQL

ENDING

BETWEEN

CONSTRAINT

DEACTIVATE

END-EXEC (COBOL only)

BINARY

CONTAINS

DEALLOCATE

ENFORCED

BIND

CONTENT

DECLARE

ERROR

BIT

CONTINUE

DEFAULT

ESCAPE

BOOLEAN

COPY

DEFAULTS

EVERY

BSON

COUNT

DEFER

EXCEPT

BUFFERPOOL

COUNT_BIG

DEFINE

EXCEPTION

Table 2. SQL Reserved Words (continued)

EXCLUDING

IDENTITY

KEYS

MONTHS

EXCLUSIVE

LABEL

NAMESPACE

EXECUTE

IGNORE

LAG

NAN

EXISTS

IMMEDIATE

LANGUAGE

NATIONAL

EXIT

IMPLICITLY

LAST_VALUE

NCHAR

EXTEND

LATERAL

NCLOB

EXTERNAL

INCLUDE

LEAD

NESTED

EXTRACT

INCLUDING

LEAVE

NEW

FALSE

INCLUSIVE

LEFT

NEW_TABLE

FENCED

INCREMENT

LEVEL2

NEXTVAL

FETCH

INDEX

FIELDPROC

INDEXBP

LIMIT

NOCACHE

FILE

INDICATOR

LINKTYPE

NOCYCLE

FINAL

INF

LISTAGG

NODENAME

FIRST_VALUE

INFINITY

LOCAL

NODENUMBER

FOR

INHERIT

LOCALDATE

NOMAXVALUE

FOREIGN

INLINE

LOCALTIME

NOMINVALUE

FORMAT

INNER

LOCALTIMESTAMP

NONE

FREE

INOUT

LOCATION

NOORDER

FREEPAGE

INSENSITIVE

LOCATOR

NORMALIZED

FROM

INSERT

LOCK

NOT

FULL

INSERTING

LOCKSIZE

NOTNULL

FUNCTION

INTEGRITY

LOG

NTH_VALUE

GBPCACHE

INTERPRET

LOGGED

NTILE

GENERAL

INTERSECT

LONG

NULL

GENERATED

INTO

LOOP

NULLS

GET

MAINTAINED

NVARCHAR

GLOBAL

ISNULL

MASK

OBID

ISOLATION

MATCHED

OBJECT

GOTO

ITERATE

MATERIALIZED

GRANT

JAVA

MAXVALUE

OFF

GRAPHIC

JOIN

MERGE

OFFSET

GROUP

JSON

MICROSECOND

OLD

HANDLER

JSON_ARRAY

MICROSECONDS

OLD_TABLE

HASH

JSON_ARRAYAGG

MINPCTUSED

OMIT

HASH_ROW

JSON_EXISTS

MINUTE

HASHED_VALUE

JSON_OBJECT

MINUTES

ONLY

HAVING

JSON_OBJECTAGG

MINVALUE

OPEN

HINT

JSON_QUERY

MIRROR

OPTIMIZE

HOLD

JSON_TABLE

MIXED

OPTION

HOUR

JSON_VALUE

MODE

HOURS

KEEP

MODIFIES

ORDER

KEY

MONTH

ORDINALITY

Table 3. SQL Reserved Words (continued)

ORGANIZE

READ

SENSITIVE

TRY_CAST

OUT

READS

SEQUENCE

TYPE

OUTER

RECOVERY

SESSION

UNDO

OVER

REFERENCES

SESSION_USER

UNION

OVERLAY

REFERENCING

SET

UNIQUE

OVERRIDING

REFRESH

SIGNAL

UNIT

PACKAGE

REGEXP_LIKE

SIMPLE

UNKNOWN

PADDED

RELEASE

SKIP

UNNEST

PAGE

RENAME

SNAN

UNTIL

PAGESIZE

REPEAT

SOME

UPDATE

PARAMETER

RESET

SOURCE

UPDATING

PART

RESIGNAL

SPECIFIC

URI

PARTITION

RESTART

SQL

USAGE

PARTITIONED

RESTRICT

SQLID

USE

PARTITIONING

RESULT

SQLIND_DEFAULT

USER

PARTITIONS

RESULT_SET_LOCATOR

SQLIND_UNASSIGNED

USERID

PASSING

RETURN

STACKED

USING

PASSWORD

RETURNING

START

VALUE

PATH

RETURNS

STARTING

VALUES

PCTFREE

REVOKE

STATEMENT

VARIABLE

PERCENT_RANK

RID

STATIC

VARIANT

PERCENTILE_CONT

RIGHT

STOGROUP

VCAT

PERCENTILE_DISC

ROLLBACK

SUBSTRING

VERSION

PERIOD

ROLLUP

SUMMARY

VERSIONING

PERMISSION

ROUTINE

SYNONYM

VIEW

PIECESIZE

ROW

SYSTEM_TIME

VOLATILE

PIPE

ROWNUMBER

SYSTEM_USER

WAIT

PLAN

ROW_NUMBER

TABLE

WHEN

POSITION

ROWS

TABLESPACE

WHENEVER

PREPARE

RRN

TABLESPACES

WHERE

PREVVAL

RUN

TAG

WHILE

PRIMARY

SAVEPOINT

THEN

WITH

PRIOR

SBCS

THREADSAFE

WITHIN

PRIQTY

SCALAR

TIME

WITHOUT

PRIVILEGES

SCHEMA

TIMESTAMP

WRAPPED

PROCEDURE

SCRATCHPAD

WRAPPER

PROGRAM

SCROLL

TRANSACTION

WRITE

PROGRAMID

TRANSFER

WRKSTNNAME

QUERY

SECOND

TRIGGER

XMLAGG

RANGE

SECONDS

TRIM

XMLATTRIBUTES

RANK

SECQTY

TRIM_ARRAY

XMLCAST

RATIO_TO_REPORT

SECURED

TRUE

XMLCOMMENT

RCDFMT

SELECT

TRUNCATE

XMLCONCAT

Table 4. SQL Reserved Words (continued)

XMLDOCUMENT

XMLPARSE

XMLTEXT

YEAR

XMLELEMENT

XMLPI

XMLVALIDATE

YEARS

XMLFOREST

XMLROW

XSLTRANSFORM

YES

XMLGROUP

XMLSERIALIZE

XSROBJECT

ZONE

XMLNAMESPACES

XMLTABLE