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.
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.
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.
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 CURRVAL1 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-EXEC2 ERASE ESCAPE EXCEPT EXCEPTION |
EXECUTE
EXISTS EXIT EXPLAIN EXTERNAL |
FENCED
FETCH FIELDPROC FINAL FIRST1 |
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 |
||
LIKE
LOCAL LOCALE LOCATOR LOCATORS |
LOCK
LOCKMAX LOCKSIZE LONG LOOP |
|
MAINTAINED
MATERIALIZED MICROSECOND MICROSECONDS MINUTE |
MINUTES
MODIFIES MONTH MONTHS |
|
NOT
NULL NULLS NUMPARTS |
||
PACKAGE
PARAMETER PART PADDED PARTITION PARTITIONED PARTITIONING |
PRIOR1
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 |
|
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 |
||
ZONE1
|
||
Note:
|