Each of the database back end supported by the ejbdeploy command have their own list of SQL reserved keywords. The following list is the SQL reserved keywords for DB2® V9.1 for Linux, UNIX, and Windows:
ABS
ABSOLUTE
ACCESS
ACTION
ACTIVATE
ADA
ADD
AFTER
ALIAS
ALL
ALLOCATE
ALLOW
ALTER
ALTERIN
ALWAYS
AND
ANY
APPEND
ARE
ARRAY
AS
ASC
ASCII
ASENSITIVE
ASSERTION
ASSOCIATE
ASUTIME
ASYMMETRIC
AT
ATOMIC
ATTRIBUTES
AUDIT
AUTHORIZATION
AUTOMATIC
AUX
AUXILIARY
AVG
BEFORE
BEGIN
BETWEEN
BIGINT
BINARY
BIND
BINDADD
BIT
BIT_LENGTH
BLOB
BLOCKED
BOOLEAN
BOTH
BUFFERPOOL
BY
C
CACHE
CALL
CALLED
CAPTURE
CARDINALITY
CASCADE
CASCADED
CASE
CAST
CATALOG
CCSID
CEIL
CEILING
CHANGE
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHECK
CHECKED
CLIENT
CLOB
CLOSE
CLUSTER
COALESCE
COBOL
COLLATE
COLLATION
COLLECT
COLLECTION
COLLID
COLUMN
COMMENT
COMMIT
COMMITTED
COMPARISONS
CONCAT
CONDITION
CONNECT
CONNECTION
CONSERVATIVE
CONSTRAINT
CONSTRAINTS
CONTAINS
CONTINUE
CONTROL
CONVERT
COPY
CORRELATION
CORR
CORRESPONDING
COUNT
COUNT_BIG
COVAR_POP
COVAR_SAMP
C++
CREATE
CREATEIN
CREATETAB
CROSS
CUBE
CUME_DIST
CURRENT
CURRENT_DATE
CURRENT_DEFAULT_TRANSFORM_GROUP
CURRENT_EXPLAIN_MODE
CURRENT_LC_CTYPE
CURRENT_PATH
CURRENT_ROLE
CURRENT_SCHEMA
CURRENT_SERVER
CURRENT_SQLID
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TIMEZONE
CURRENT_TRANSFORM_GROUP_FOR_TYPE
CURRENT_USER
CURSOR
CYCLE
DATA
DATABASE
DATALINK
DATAPARTITIONNAME
DATAPARTITIONNUM
DATE
DAY
DAYS
DB
DBADM
DBCLOB
DBINFO
DB2DARI
DB2GENRL
DB2GENERAL
DB2SQL
DBPARTITIONNAME
DBPARTITIONNUM
DEADLOCKS
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFAULTS
DEFINE
DEFINITION
DEGREE
DEFERRABLE
DEFERRED
DELETE
DENSE_RANK
DENSERANK
DEREF
DESC
DESCRIBE
DESCRIPTOR
DSSIZE
DETERMINISTIC
DIAGNOSTICS
DIMENSIONS
DISABLE
DISALLOW
DISCONNECT
DISTINCT
DOMAIN
DO
DOUBLE
DROP
DROPIN
DYNAMIC
EACH
EBCDIC
EDITPROC
ELEMENT
ELSE
ELSEIF
ENABLE
ENCODING
ENCRYPTION
END
END-EXEC
ENDING
ERASE
ESCAPE
EUR
EVENT
EVERY
EXACT
EXCEPT
EXCEPTION
EXCLUDE
EXCLUDING
EXCLUSIVE
EXEC
EXECUTE
EXISTS
EXIT
EXP
EXPLAIN
EXTENSION
EXTERNAL
EXTRACT
FALSE
FEDERATED
FENCED
FETCH
FIELDPROC
FILE
FILTER
FINAL
FIRST
FLOAT
FLOOR
FLUSH
FOLLOWING
FOR
FORCE
FOREIGN
FORTRAN
FOUND
FREE
FROM
FS
FULL
FUNCTION
FUSION
G
GENERAL
GENERATED
GET
GLOBAL
GO
GOTO
GRANT
GRAPHIC
GROUP
GROUPING
HANDLER
HASH
HASHED_VALUE
HAVING
HINT
HOLD
HOUR
HOURS
IDENTITY
IF
IMMEDIATE
IMPLICIT_SCHEMA
IN
INCLUDE
INCLUDING
INCLUSIVE
INCREMENT
INDEX
INDICATOR
INHERIT
INITIALLY
INITIAL_INSTS
INITIAL_IOS
INNER
INOUT
INPUT
INSENSITIVE
INSERT
INSTEAD
INSTS_PER_ARGBYTE
INSTS_PER_INVOC
INT
INTEGER
INTEGRITY
INTERSECT
INTERSECTION
INTERVAL
INTO
IOS_PER_ARGBYTE
IOS_PER_INVOC
IS
ISO
ISOBID
ISOLATION
ITERATE
JAR
JAVA
JIS
JOIN
K
KEY
LABEL
LANGUAGE
LARGE
LAST
LATERAL
LC_CTYPE
LEADING
LEAVE
LEFT
LENGTH
LEVEL
LIKE
LIMIT
LINK
LINKTYPE
LN
LOAD
LOCAL
LOCALDATE
LOCALE
LOCALTIME
LOCALTIMESTAMP
LOCATOR
LOCATORS
LOCK
LOCKMAX
LOCKS
LOCKSIZE
LONG
LONGVAR
LOOP
LOWER
M
MAINTAINED
MAPPING
MATCH
MATERIALIZED
MAX
MAXVALUE
MEMBER
MERGE
METHOD
MICROSECOND
MICROSECONDS
MIN
MINUTE
MINUTES
MINVALUE
MOD
MODE
MODIFIES
MODULE
MONITOR
MONTH
MONTHS
MULTISET
NAMED
NAMES
NATIONAL
NATURAL
NCHAR
NCLOB
NEW
NEW_TABLE
NEXT
NEXTVAL
NICKNAME
NO
NOCACHE
NOCYCLE
NODE
NODENAME
NODENUMBER
NOMAXVALUE
NOMINVALUE
NONE
NOORDER
NORMALIZE
NORMALIZED
NOT
NULL
NULLABLE
NULLIF
NULLS
NUMBER
NUMERIC
NUMPARTS
OBID
OBJECT
OCTET_LENGTH
OF
OFF
OLD
OLD_TABLE
OLE
OLEDB
ON
ONCE
ONLINE
ONLY
OPEN
OPTIMIZATION
OPTIMIZE
OPTION
OR
ORDER
OUT
OUTER
OUTPUT
OVER
OVERLAY
OVERLAPS
OVERRIDING
PACKAGE
PAD
PADDED
PAGESIZE
PART
PARTIAL
PARTITIONED
PARTITIONING
PARTITIONS
PARALLEL
PARAMETER
PASCAL
PASSTHRU
PASSWORD
PATH
PARTITION
PCTFREE
PERCENT_ARGBYTES
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
PERMISSION
PIECESIZE
PIPE
PLAN
PLI
POSITION
POWER
PRECEDING
PRECISION
PREPARE
PRESERVE
PREVVAL
PRIMARY
PRIOR
PRIQTY
PRIVILEGES
PROCEDURE
PROGRAM
PSID
PUBLIC
QUERY
QUERYNO
RANGE
READ
READS
REAL
RECOMMEND
RECOVERY
RECURSIVE
REF
REFERENCE
REFERENCES
REFERENCING
REFRESH
REGISTERS
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
RELATIVE
RELEASE
RENAME
REPEATABLE
REPEAT
REPLACE
REPLICATED
RESET
RESIGNAL
RESOLVE
RESTART
RESTORE
RESTRICT
RESULT
RESULT_SET_LOCATOR
RETAIN
RETURN
RETURNS
RETURN_STATUS
REVOKE
RIGHT
ROLLBACK
ROLLUP
ROUTINE
ROW
ROWID
ROWNUMBER
ROWS
ROWSET
ROW_COUNT
RRN
RUN
S
SAVEPOINT
SBCS
SCALE
SCHEMA
SCOPE
SCRATCHPAD
SCROLL
SEARCH
SECOND
SECONDS
SECQTY
SECTION
SECURITY
SELECT
SELECTIVITY
SELF
SENSITIVE
SEQUENCE
SERIALIZABLE
SERVER
SESSION
SESSION_USER
SET
SETS
SHARE
SIGNAL
SIMILAR
SIMPLE
SIZE
SMALLINT
SNAPSHOT
SOME
SOURCE
SPACE
SPECIFIC
SPECIFICTYPE
SQL
SQLCODE
SQLERROR
SQLEXCEPTION
SQLWARNING
SQLID
SQLSTATE
SQRT
STACKED
STANDARD
START
STARTING
STATE
STATEMENT
STATIC
STATISTICS
STAY
STDDEV_POP
STDDEV_SAMP
STOGROUP
STORAGE
STORES
STYLE
SUBMULTISET
SUBSTRING
SUM
SUMMARY
SWITCH
SYMMETRIC
SYNONYM
SYSFUN
SYSIBM
SYSPROC
SYSTEM
SYSTEM_USER
TABLE
TABLES
TABLE_NAME
TABLESPACE
TABLESPACES
TARGET
TEMPLATE
TEMPORARY
THEN
THREADSAFE
TIME
TIMESTAMP
TIMEZONE
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TRAILING
TRANSACTION
TRANSFORM
TRANSLATE
TRANSLATION
TREAT
TRIGGER
TRIM
TRUE
TYPE
UESCAPE
UNBOUNDED
UNCOMMITTED
UNDER
UNDO
UNICODE
UNION
UNIQUE
UNKNOWN
UNNEST
UNTIL
UPDATE
UPPER
URL
USA
USE
USAGE
USER
USING
VALIDPROC
VALUE
VALUES
VARCHAR
VARGRAPHIC
VARIABLE
VARIANT
VARYING
VAR_POP
VAR_SAMP
VCAT
VERSION
VIEW
VOLATILE
VOLUMES
WHEN
WHENEVER
WHERE
WHILE
WIDTH_BUCKET
WINDOW
WITH
WITHIN
WITHOUT
WLM
WORK
WRAPPER
WRITE
XMLELEMENT
XMLEXISTS
YEAR
YEARS
YES
ZONE