Appendix B

SQL Keywords

The following words are considered SQL keywords and therefore cannot be used to name objects.

ADD DISALLOW LABEL REFERENCING
ALIAS DISCONNECT LANGUAGE REFRESH
ALL DISTINCT LATERAL RELEASE
ALLOCATE DO LEAVE RENAME
ALLOW DOUBLE LEFT REPEAT
ALTER DROP LIKE RESET
AND DYNAMIC LINKTYPE RESIGNAL
ANY EACH LOCALDATE RESTART
AS ELSE LOCALTIME RESULT
ASENSITIVE ELSEIF LOCALTIMESTAMP RETURN
AT ENABLE LOCK RETURNS
ATTRIBUTES ENCRYPTION LONG REVOKE
AUTHORIZATION END LOOP RIGHT
BEGIN ENDING MAINTAINED ROLLBACK
BETWEEN END-EXEC (COBOL only) MATERIALIZED ROUTINE
BINARY ESCAPE MAXVALUE ROW
BY EVERY MICROSECOND ROWS
CACHE EXCEPT MICROSECONDS RRN
CALL EXCEPTION MINUTE RUN
CALLED EXCLUDING MINUTES SAVEPOINT
CARDINALITY EXCLUSIVE MINVALUE SCHEMA
CASE EXECUTE MODE SCRATCHPAD
CAST EXISTS MODIFIES SCROLL
CCSID EXIT MONTH SECOND
CHAR EXTERNAL MONTHS SECONDS
CHARACTER EXTRACT NEW SELECT
CHECK FENCED NEW_TABLE SENSITIVE
CLOSE FETCH NEXT SEQUENCE
COLLECTION FILE NEXTVAL SET
COLUMN FINAL NO SIGNAL
COMMENT FOR NOCACHE SIMPLE
COMMIT FOREIGN NOCYCLE SOME
CONCAT FREE NODENAME SOURCE
CONDITION FROM NODENUMBER SPECIFIC
CONNECT FUNCTION NOMAXVALUE SQL
CONNECTION GENERAL NOMINVALUE SQLID
CONSTRAINT GENERATED NOORDER STACKED
CONTAINS GET NORMALIZED START
CONTINUE GLOBAL NOT STARTING
COUNT GO NULL STATEMENT
COUNT_BIG GOTO OF STATIC
CREATE GRANT OLD SUBSTRING
CROSS GRAPHIC OLD_TABLE SUMMARY
CURRENT GROUP ON SYNONYM
CURRENT_DATE HANDLER OPEN TABLE
CURRENT_PATH HASH OPTIMIZE THEN
CURRENT_SERVER HASHED_VALUE OPTION TIME
CURRENT_TIME HAVING OR TIMESTAMP
CURRENT_TIMESTAMP HINT ORDER TO
CURRENT_TIMEZONE HOLD OUT TRANSACTION
CURRENT_USER HOUR OUTER TRIGGER
CURSOR HOURS OVERRIDING TRIM
CYCLE IDENTITY PACKAGE TYPE
DATABASE IF PARAMETER UNDO
DATAPARTITIONNAME IMMEDIATE PART UNION
DATAPARTITIONNUM IN PARTITION UNIQUE
DATE INCLUDING PARTITIONING UNTIL
DAY INCLUSIVE PARTITIONS UPDATE
DAYS INCREMENT PASSWORD USAGE
DBINFO INDEX PATH USER
DBPARTITIONNAME INDICATOR POSITION USING
DBPARTITIONNUM INNER PREPARE VALUES
DB2GENERAL INOUT PREVIOUS VARIABLE
DB2GENRL INSENSITIVE PREVVAL VARIANT
DB2SQL INSERT PRIMARY VERSION
DECLARE INTEGRITY PRIVILEGES VIEW
DEFAULT INTERSECT PROCEDURE WHEN
DEFAULTS INTO PROGRAM WHERE
DEFINITION IS QUERY WHILE
DELETE ISOLATION RANGE WITH
DESCRIPTOR ITERATE READ WITHOUT
DETERMINISTIC JAVA READS WRITE
DIAGNOSTICS JOIN RECOVERY YEAR
DISABLE KEY REFERENCES YEARS

*Note: Depending on the level of OS/400 on your iSeries and the available higher-level language compilers, some keywords/functions may not be available.