IBM Books

SQL Reference


IBM SQL Reserved Words

The IBM SQL reserved words are as follows.
ACQUIRE DATABASE IDENTIFIED OBID SCHEDULE
ADD DATE IMMEDIATE OF SCHEMA
ALL DAY IN ON SECOND
ALLOCATE DAYS INDEX ONLY SECONDS
ALTER DBA INDICATOR OPTIMIZE SECQTY
AND DBSPACE INNER OPTION SELECT
ANY DEFAULT INOUT OR SET
AS DELETE INSERT ORDER SHARE
ASC DESC INTERSECT OUT SIMPLE
AUDIT DESCRIPTOR INTO OUTER SOME
AUTHORIZATION DISTINCT IS
STATISTICS
AVG DOUBLE ISOLATION PACKAGE STOGROUP

DROP
PAGE STORPOOL
BETWEEN
JOIN PAGES SUBPAGES
BUFFERPOOL EDITPROC
PART SUBSTRING
BY END-EXEC KEY PCTFREE SUM

ELSE
PCTINDEX SYNONYM
CALL ERASE LABEL PLAN
CAPTURE ESCAPE LEFT PRECISION TABLE
CASE EXCEPT LIKE PRIMARY TABLESPACE
CAST EXCEPTION LOCK PRIQTY TO
CCSID EXCLUSIVE LOCKSIZE PRIVATE TRANSACTION
CHAR EXECUTE LONG PRIVILEGES TRIM
CHARACTER EXISTS
PROCEDURE
CHECK EXPLAIN MAX PROGRAM UNION
CLUSTER EXTERNAL MICROSECOND PUBLIC UNIQUE
COLLECTION
MICROSECONDS
UPDATE
COLUMN FETCH MIN REFERENCES USER
COMMENT FIELDPROC MINUTE RELEASE USING
COMMIT FOR MINUTES RESET
CONCAT FOREIGN MODE RESOURCE VALIDPROC
CONNECT FROM MONTH REVOKE VALUES
CONNECTION FULL MONTHS RIGHT VARIABLE
CONSTRAINT

ROLLBACK VCAT
COUNT GO NAMED ROW VIEW
CREATE GOTO NHEADER ROWS VOLUMES
CROSS GRANT NOT RRN
CURRENT GRAPHIC NULL RUN WHERE
CURRENT_DATE GROUP NUMPARTS
WITH
CURRENT_SERVER


WORK
CURRENT_TIME HAVING


CURRENT_TIMESTAMP HOUR

YEAR
CURRENT_TIMEZONE HOURS

YEARS
CURRENT_USER



CURSOR




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

[ DB2 List of Books | Search the DB2 Books ]