Reserved words

Certain words cannot be used as ordinary identifiers in some contexts because those words might be interpreted as SQL keywords. For example, ALL cannot be a column name in a SELECT statement. Each word, however, can be used as a delimited identifier in contexts where it otherwise cannot be used as an ordinary identifier. For example, if the quotation mark (") is the escape character that begins and ends delimited identifiers, "ALL" can appear as a column name in a SELECT statement.

Start of change Certain keywords might be interpreted as ordinary identifiers in some contexts rather than as keywords. For example, in the statement SELECT * FROM SYSIBM.SYSTABLES WHERE, WHERE is interpreted as an ordinary identifier specified as a correlation name, rather than as the beginning of an incomplete WHERE clause. End of change

New reserved words for this version of DB2® for z/OS® are identified with notes in this topic. In addition, some topics in this information might indicate words that cannot be used in the specific context that is being described.

IBM® SQL has additional reserved words that DB2 for z/OS does not enforce. Therefore, you should not use these additional reserved words as ordinary identifiers in names that have a continuing use. See IBM DB2 SQL Reference for Cross-Platform Development for a list of the words.

Begin general-use programming interface information.

ADD AFTER ALL ALLOCATE ALLOW ALTER	AND ANY AS ASENSITIVE ASSOCIATE	ASUTIME AT AUDIT AUX AUXILIARY
BEFORE BEGIN BETWEEN BUFFERPOOL BY
CALL CAPTURE CASCADED CASE CAST CCSID CHAR CHARACTER CHECK CLONE CLOSE CLUSTER	COLLECTION COLLID COLUMN COMMENT COMMIT CONCAT CONDITION CONNECT CONNECTION CONSTRAINT CONTAINS CONTENT	CONTINUE CREATE CURRENT CURRENT_DATE CURRENT_LC_CTYPE CURRENT_PATH CURRENT_SCHEMA CURRENT_TIME CURRENT_TIMESTAMP CURRVAL¹ CURSOR
DATA DATABASE DAY DAYS DBINFO DECLARE DEFAULT	DELETE DESCRIPTOR DETERMINISTIC DISABLE DISALLOW DISTINCT	DO DOCUMENT DOUBLE DROP DSSIZE DYNAMIC
EDITPROC ELSE ELSEIF ENCODING ENCRYPTION END	ENDING END-EXEC² ERASE ESCAPE EXCEPT EXCEPTION	EXECUTE EXISTS EXIT EXPLAIN EXTERNAL
FENCED FETCH FIELDPROC FINAL FIRST¹	FOR FREE FROM FULL FUNCTION
GENERATED GET GLOBAL GO GOTO	GRANT GROUP
HANDLER HAVING HOLD HOUR HOURS
IF IMMEDIATE IN INCLUSIVE INDEX	INHERIT INNER INOUT INSENSITIVE	INSERT INTERSECT INTO IS ISOBID ITERATE
JAR JOIN
KEEP KEY
LABEL LANGUAGE LAST¹ LC_CTYPE LEAVE LEFT	LIKE LOCAL LOCALE LOCATOR LOCATORS	LOCK LOCKMAX LOCKSIZE LONG LOOP
MAINTAINED MATERIALIZED MICROSECOND MICROSECONDS MINUTE	MINUTES MODIFIES MONTH MONTHS
NEXT¹ NEXTVAL NO NONE	NOT NULL NULLS NUMPARTS
OBID OF OLD¹ ON OPEN OPTIMIZATION	OPTIMIZE OR ORDER ORGANIZATION¹ OUT OUTER
PACKAGE PARAMETER PART PADDED PARTITION PARTITIONED PARTITIONING	PATH PIECESIZE PERIOD¹ PLAN PRECISION PREPARE PREVVAL	PRIOR¹ PRIQTY PRIVILEGES PROCEDURE PROGRAM PSID PUBLIC
QUERY QUERYNO
READS REFERENCES REFRESH RESIGNAL RELEASE RENAME REPEAT RESTRICT RESULT	RESULT_SET_LOCATOR RETURN RETURNS REVOKE RIGHT ROLE ROLLBACK ROUND_CEILING	ROUND_DOWN ROUND_FLOOR ROUND_HALF_DOWN ROUND_HALF_EVEN ROUND_HALF_UP ROUND_UP ROW ROWSET RUN
SAVEPOINT SCHEMA SCRATCHPAD SECOND SECONDS SECQTY SECURITY SEQUENCE SELECT SENSITIVE SESSION_USER	SET SIGNAL SIMPLE SOME SOURCE SPECIFIC STANDARD STATIC STATEMENT STAY	STOGROUP STORES STYLE SUMMARY SYNONYM SYSDATE¹SYSTEM SYSTIMESTAMP¹
TABLE TABLESPACE THEN TO TRIGGER	TRUNCATE TYPE
UNDO UNION UNIQUE UNTIL UPDATE	USER USING
VALIDPROC VALUE VALUES VARIABLE VARIANT	VCAT VIEW VOLATILE VOLUMES
WHEN WHENEVER WHERE WHILE WITH WLM
XMLEXISTS XMLNAMESPACES XMLCAST
YEAR YEARS
ZONE¹
Note: New reserved word for DB2 10. COBOL only

End general-use programming interface information.