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 | BY | 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 | CL | CURRENT_TIMESTAMP | DISABLE |
| ANY | CLOSE | CURRENT_TIMEZONE | DISALLOW |
| APPEND | CLUSTER | CURRENT_USER | DISCONNECT |
| APPLNAME | COLLECT | CURSOR | DISTINCT |
| ARRAY | COLLECTION | CYCLE | DO |
| ARRAY_AGG | COLUMN | DATA | DOCUMENT |
| ARRAY_TRIM | COMMENT | DATABASE | DOUBLE |
| AS | 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 | IF | LABEL | NAMESPACE |
| EXECUTE | IGNORE | LAG | NAN |
| EXISTS | IMMEDIATE | LANGUAGE | NATIONAL |
| EXIT | IMPLICITLY | LAST_VALUE | NCHAR |
| EXTEND | IN | LATERAL | NCLOB |
| EXTERNAL | INCLUDE | LEAD | NESTED |
| EXTRACT | INCLUDING | LEAVE | NEW |
| FALSE |
INCLUSIVE | LEFT | NEW_TABLE |
| FENCED | INCREMENT | LEVEL2 | NEXTVAL |
| FETCH | INDEX | LIKE | NO |
| 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 | IS | MAINTAINED | NVARCHAR |
| GLOBAL | ISNULL | MASK | OBID |
| GO | ISOLATION | MATCHED | OBJECT |
| GOTO | ITERATE | MATERIALIZED | OF |
| 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 | ON |
| 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 | OR |
| HOURS | KEEP | MODIFIES | ORDER |
| ID | 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 | TO | WRAPPER |
| PROGRAM | SCROLL | TRANSACTION | WRITE |
| PROGRAMID | SEARCH | 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 |