id="wordsre">Reserved words

This is the list of currently reserved DB2 for i5/OS 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 IBM SQL Reference Version 1 SC26-3255.

Table 177. SQL Reserved Words

ACTIVATE ADD ALIAS ALL ALLOCATE ALLOW ALTER AND ANY AS ASENSITIVE AT ATTRIBUTES AUTHORIZATION BEGIN BETWEEN BINARY BY CACHE CALL CALLED CARDINALITY CASE CAST CCSID CHAR CHARACTER CHECK CLOSE COLLECTION COLUMN COMMENT COMMIT CONCAT CONDITION CONNECT CONNECTION CONSTRAINT CONTAINS CONTINUE COUNT COUNT_BIG CREATE CROSS CURRENT CURRENT_DATE CURRENT_PATH CURRENT_SCHEMA

CURRENT_SERVER CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TIMEZONE CURRENT_USER CURSOR CYCLE DATABASE DATAPARTITIONNAME DATAPARTITIONNUM DATE DAY DAYS DBINFO DBPARTITIONNAME DBPARTITIONNUM DB2GENERAL DB2GENRL DB2SQL DEALLOCATE DECLARE DEFAULT DEFAULTS DEFINITION DELETE DENSERANK DENSE_RANK DESCRIBE DESCRIPTOR DETERMINISTIC DIAGNOSTICS DISABLE DISALLOW DISCONNECT DISTINCT DO DOUBLE DROP DYNAMIC EACH ELSE ELSEIF ENABLE ENCRYPTION END ENDING END-EXEC (COBOL only) ESCAPE

EVERY EXCEPT EXCEPTION EXCLUDING EXCLUSIVE EXECUTE EXISTS EXIT EXTERNAL EXTRACT FENCED FETCH FILE FINAL FOR FOREIGN FREE FROM FULL FUNCTION GENERAL GENERATED GET GLOBAL GO GOTO GRANT GRAPHIC GROUP HANDLER HASH HASHED_VALUE HAVING HINT HOLD HOUR HOURS IDENTITY IF IMMEDIATE IN INCLUDING INCLUSIVE INCREMENT INDEX INDICATOR INHERIT INNER

INOUT INSENSITIVE INSERT INTEGRITY INTERSECT INTO IS ISOLATION ITERATE JAVA JOIN KEY LABEL LANGUAGE LATERAL LEAVE LEFT LIKE LINKTYPE LOCAL LOCALDATE LOCALTIME LOCALTIMESTAMP LOCK LONG LOOP MAINTAINED MATERIALIZED MAXVALUE MICROSECOND MICROSECONDS MINUTE MINUTES MINVALUE MODE MODIFIES MONTH MONTHS NEW NEW_TABLE NEXTVAL NO NOCACHE NOCYCLE NODENAME NODENUMBER NOMAXVALUE NOMINVALUE

Table 178. SQL Reserved Words (continued)

NOORDER NORMALIZED NOT NULL OF OLD OLD_TABLE ON OPEN OPTIMIZE OPTION OR ORDER OUT OUTER OVER OVERRIDING PACKAGE PAGESIZE PARAMETER PART PARTITION PARTITIONING PARTITIONS PASSWORD PATH POSITION PREPARE PREVVAL PRIMARY PRIVILEGES

PROCEDURE PROGRAM QUERY RANGE RANK READ READS RECOVERY REFERENCES REFERENCING REFRESH RELEASE RENAME REPEAT RESET RESIGNAL RESTART RESULT RETURN RETURNS REVOKE RIGHT ROLLBACK ROUTINE ROW ROWNUMBER ROW_NUMBER ROWS RRN RUN SAVEPOINT

SCHEMA SCRATCHPAD SCROLL SEARCH SECOND SECONDS SELECT SENSITIVE SEQUENCE SESSION SESSION_USER SET SIGNAL SIMPLE SOME SOURCE SPECIFIC SQL SQLID STACKED START STARTING STATEMENT STATIC SUBSTRING SUMMARY SYNONYM SYSTEM_USER TABLE THEN

TIME TIMESTAMP TO TRANSACTION TRIGGER TRIM TYPE UNDO UNION UNIQUE UNTIL UPDATE USAGE USER USING VALUE VALUES VARIABLE VARIANT VERSION VIEW VOLATILE WHEN WHERE WHILE WITH WITHOUT WRITE YEAR YEARS

---

[ Top of Page | Previous Page | Next Page | Contents |
Index ]