SQL Reference
The IBM SQL reserved words are as follows.
| ACQUIRE
| CONNECT
| EDITPROC
| IN
|
| ADD
| CONNECTION
| ELSE
| INDEX
|
| AFTER
| CONSTRAINT
| ELSEIF
| INDICATOR
|
| ALIAS
| CONTAINS
| END
| INNER
|
| ALL
| CONTINUE
| END-EXEC
| INOUT
|
| ALLOCATE
| COUNT
| ERASE
| INSENSITIVE
|
| ALLOW
| COUNT_BIG
| ESCAPE
| INSERT
|
| ALTER
| CREATE
| EXCEPT
| INTEGRITY
|
| AND
| CROSS
| EXCEPTION
| INTERSECT
|
| ANY
| CURRENT
| EXCLUSIVE
| INTO
|
| AS
| CURRENT_DATE
| EXECUTE
| IS
|
| ASC
| CURRENT_LC_PATH
| EXISTS
| ISOBID
|
| ASUTIME
| CURRENT_PATH
| EXIT
| ISOLATION
|
| AUDIT
| CURRENT_SERVER
| EXPLAIN
|
|
| AUTHORIZATION
| CURRENT_TIME
| EXTERNAL
| JAVA
|
| AUX
| CURRENT_TIMESTAMP
|
| JOIN
|
| AUXILIARY
| CURRENT_TIMEZONE
| FENCED
|
|
| AVG
| CURRENT_USER
| FETCH
| KEY
|
| CURSOR
| FIELDPROC
|
|
| BEFORE
|
| FILE
| LABEL
|
| BEGIN
| DATA
| FINAL
| LANGUAGE
|
| BETWEEN
| DATABASE
| FOR
| LC_CTYPE
|
| BINARY
| DATE
| FOREIGN
| LEAVE
|
| BUFFERPOOL
| DAY
| FREE
| LEFT
|
| BY
| DAYS
| FROM
| LIKE
|
| DBA
| FULL
| LINKTYPE
|
| CALL
| DBINFO
| FUNCTION
| LOCAL
|
| CALLED
| DBSPACE
|
| LOCALE
|
| CAPTURE
| DB2GENERAL
| GENERAL
| LOCATOR
|
| CASCADED
| DB2SQL
| GENERATED
| LOCATORS
|
| CASE
| DECLARE
| GO
| LOCK
|
| CAST
| DEFAULT
| GOTO
| LOCKSIZE
|
| CCSID
| DELETE
| GRANT
| LONG
|
| CHAR
| DESC
| GRAPHIC
| LOOP
|
| CHARACTER
| DESCRIPTOR
| GROUP
|
|
| CHECK
| DETERMINISTIC
|
| MAX
|
| CLOSE
| DISALLOW
| HANDLER
| MICROSECOND
|
| CLUSTER
| DISCONNECT
| HAVING
| MICROSECONDS
|
| COLLECTION
| DISTINCT
| HOUR
| MIN
|
| COLLID
| DO
| HOURS
| MINUTE
|
| COLUMN
| DOUBLE
|
| MINUTES
|
| COMMENT
| DROP
| IDENTIFIED
| MODE
|
| COMMIT
| DSSIZE
| IF
| MODIFIES
|
| CONCAT
| DYNAMIC
| IMMEDIATE
| MONTH
|
| CONDITION
|
|
| MONTHS
|
| NAME
| PACKAGE
| SCHEDULE
| UNDO
|
| NAMED
| PAGE
| SCHEMA
| UNION
|
| NHEADER
| PAGES
| SCRATCHPAD
| UNIQUE
|
| NO
| PARAMETER
| SECOND
| UNTIL
|
| NODENAME
| PART
| SECONDS
| UPDATE
|
| NODENUMBER
| PARTITION
| SECQTY
| USAGE
|
| NOT
| PATH
| SECURITY
| USER
|
| NULL
| PCTFREE
| SELECT
| USING
|
| NULLS
| PCTINDEX
| SET
|
|
| NUMPARTS
| PIECESIZE
| SHARE
| VALIDPROC
|
| PLAN
| SIMPLE
| VALUES
|
| OBID
| POSITION
| SOME
| VARIABLE
|
| OF
| PRECISION
| SOURCE
| VARIANT
|
| ON
| PREPARE
| SPECIFIC
| VCAT
|
| ONLY
| PRIMARY
| SQL
| VIEW
|
| OPEN
| PRIQTY
| STANDARD
| VOLUMES
|
| OPTIMIZATION
| PRIVATE
| STATIC
|
|
| OPTIMIZE
| PRIVILEGES
| STATISTICS
| WHEN
|
| OPTION
| PROCEDURE
| STAY
| WHERE
|
| OR
| PROGRAM
| STOGROUP
| WHILE
|
| ORDER
| PSID
| STORES
| WITH
|
| OUT
| PUBLIC
| STORPOOL
| WLM
|
| OUTER
|
| STYLE
| WORK
|
| QUERYNO
| SUBPAGES
| WRITE
|
|
| SUBSTRING
|
|
| READ
| SUM
| YEAR
|
| READS
| SYNONYM
| YEARS
|
| RECOVERY
|
|
|
| REFERENCES
| TABLE
|
|
| RELEASE
| TABLESPACE
|
|
| RENAME
| THEN
|
|
| REPEAT
| TO
|
|
| RESET
| TRANSACTION
|
|
| RESOURCE
| TRIGGER
|
|
| RESTRICT
| TRIM
|
|
| RESULT
| TYPE
|
|
| RETURN
|
|
|
| RETURNS
|
|
|
| REVOKE
|
|
|
| RIGHT
|
|
|
| ROLLBACK
|
|
|
| ROW
|
|
|
| ROWS
|
|
|
| RRN
|
|
|
| RUN
|
|
|
[ Top of Page | Previous Page | Next Page ]