Answer

Note that just because a word is added to the SQL Reserved Words list does not mean it is "reserved" everywhere within an SQL statement.

An example is V5R4 reserved word ACTIVATE.
ACTIVATE is only reserved in the row and column access control (RCAC) context.
You can still name a table ACTIVATE, for example.

You should always refer to the DB2 for i SQL Reference and each Technology Refresh for each release.
This technote can be used a quick reference for all recent IBM i releases.

Words can be added at any time Do not consider this technote as the definitive list.
This list may not accurately reflect which keywords have been PTF'd back to a previous IBM i release
 

IBM i 7.5
 

BOOLEAN
BSON
FALSE
JSON
KEYS
MIRROR
OBJECT
OFF
SCALAR
TRUE
TRY_CAST
UNKNOWN
 

IBM i 7.4
 

ARRAY_TRIM
COMPARISONS
HASH_ROW
INTERPRET
NTH_VALUE
SQLIND_DEFAULT
SQLIND_UNASSIGNED

IBM i 7.3

ATTACH
CUME_DIST
DETACH
ERROR
FIRST_VALUE
INLINE
LAG
LAST_VALUE
LEAD
NTH_VALUE
NTILE
PERCENTILE_CONT
PERCENTILE_DISC
PERIOD
RATIO_TO_REPORT
REGEXP_LIKE
SYSTEM_TIME
VERSIONING



IBM i 7.2

AUTONOMOUS
CONSTANT
DELETING
INSERTING
KEEP
LIMIT (Some LIMIT support is available on IBM i 7.1)
MASK
OFFSET
OVERLAY
PASSING
PERMISSION
PIPE
PRIOR
REGEXP_LIKE
SECURED
TRANSFER
TRUNCATE
UPDATING
WRAPPED
XMLTABLE



IBM i 7.1

ACCORDING
ACCTNG
APPLNAME
ARRAYY
ARRAY_AGG
ASSOCIATE
ATOMICUP
BEFOREPACE
CLBLESPACES
CONCURRENT
CONNECT_BY_ROOT
CONTENT
DOCUMENT
FIELDPROC
ID
IGNORE
LOCATION
LOCATOR
MATCHED
MERGE
NAMESPACE
ORDINALITY
PASSING
PRIOR
PROGRAMID
RESULT_SET_LOCATOR
THREADSAFE
TRIM_ARRAY
UNIT
UNNEST
URI
USE
USERID
VALUE
WAIT
WHENEVER
WRAPPED
WRKSTNNAME
XMLAGG
XMLATTRIBUTES
XMLCAST
XMLCOMMENT
XMLCONCAT
XMLDOCUMENT
XMLELEMENT
XMLFOREST
XMLGROUP
XMLNAMESPACES
XMLPARSE
XMLPI
XMLROW
XMLSERIALIZE
XMLTABLE
XMLTEXT
XMLVALIDATE
XSLTRANSFORM
XSROBJECT



V6R1

ACTION
APPEND
BIND
BIT
BUFFERPOOL
CLUSTER
COLLECT
COMPACT
COMPRESS
COPY
CUBE
DATA
DEACTIVATE
DEFER
DEFINE
ENFORCED
FREEPAGE
GBPCACHE
IMPLICITLY
INCLUDE
INDEXBP
INF
INFINITY
LEVEL2
LOCKSIZE
LOG
LOGGED
MINPCTUSED
MIXED
NAN
NATIONAL
NCHARCHE
NCLOBCITLY
NONEUDE
NULLSBP
NVARCHAR
OBIDNITY
ORGANIZE
PADDEDZE
PAGE
PARTITIONED
PCTFREESED
PIECESIZE
PLAN
PRIQTY
RID
ROLLUP
SBCS
SECQTY
SKIP
SNAN
STOGROUP
TABLESPACE
TABLESPACES
VCAT
YES



V5R4

ACTIVATE
DEALLOCATE
DENSERANK
DENSE_RANK
DESCRIBE
FULL
INHERIT
LOCAL
OVER
PAGESIZE
RANK
RCDFMT
ROWNUMBER
ROW_NUMBER
SEARCH
SESSION
SESSION_USER
SYSTEM_USER
VOLATILE

Words can be added at any time Do not consider this technote as the definitive list.