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.8 for Linux, UNIX, and Windows:
ACCESS
ACCESSCTRL
ACCORDING
ACCTNG
ACTION
ACTIVATE
ACTIVITIES
ACTIVITY
ACTIVITYSTMT
ACTIVITYTOTALTIME
ACTIVITYVALS
ADD
ADMIN
ADMINISTRATION
AFTER
AGE
AGENT
AGGREGATE
AGGSQLTEMPSPACE
ALIAS
ALL
ALLOCATE
ALLOW
ALTER
ALTERIN
ALWAYS
ANCHOR
AND
ANY
APPEND
APPLICATION
APPLNAME
APPL_ID
APPL_NAME
APPROXIMATION
APREUSE
ARRAY
ARRAY_AGG
ARRAY_EXISTS
AS
ASC
ASCII
ASENSITIVE
ASSIGNMENT
ASSOCIATE
AST
ASUTIME
ASYNCHRONY
AT
ATOMIC
ATTACH
ATTACHED
ATTRIBUTE
ATTRIBUTES
AUDIT
AUTHENTICATION
AUTHID
AUTHORIZATION
AUTHORIZATIONS
AUTHORIZED
AUTH_ID
AUTO
AUTOMATIC
AUTONOMOUS
AUTORESIZE
AUTOSTART
AUTOTYPE
AVAILABLE
B
BASE
BASE64
BASED
BEFORE
BEGIN
BERNOULLI
BETWEEN
BIGINT
BIN
BINARY
BIND
BINDADD
BIT
BLOB
BLOCKED
BLOCKINSERT
BLOCKSIZE
BODY
BOOLEAN
BOTH
BUFFER
BUFFERPOOL
BUFFERPOOLS
BUFFERSIZE
BUILD
BY
BYPASS
C
CACHE
CACHING
CALL
CALLED
CALLER
CAPTURE
CARDINALITIES
CARDINALITY
CASCADE
CASCADED
CASE
CAST
CATEGORIES
CCSID
CHANGE
CHANGED
CHANGES
CHAR
CHARACTER
CHECK
CHECKED
CHECKING
CLASS
CLEANUP
CLIENT
CLIENT_ACCTNG
CLIENT_APPLNAME
CLIENT_USERID
CLIENT_WRKSTNNAME
CLOB
CLOSE
CLR
CLUSTER
COBOL
CODEUNITS16
CODEUNITS32
COLLECT
COLLECTION
COLLID
COLUMN
COLUMNS
COMM
COMMENT
COMMIT
COMMITTED
COMPACT
COMPARE
COMPARISONS
COMPILATION
COMPILEDFUNCTION
COMPILEDTRIGGER
COMPONENT
COMPONENTS
COMPRESS
COMPRESSION
CONCAT
CONCURRENTDBCOORDACTIVITIES
CONCURRENTWORKLOADACTIVITIES
CONCURRENTWORKLOADOCCURRENCES
CONDITION
CONN
CONNECT
CONNECTION
CONNECTIONIDLETIME
CONNECTIONS
CONNECTOPT
CONNECT_BY_ROOT
CONNHEADER
CONNMEMUSE
CONSERVATIVE
CONSTANT
CONSTRAINED
CONSTRAINT
CONSTRAINTS
CONSTRUCTOR
CONTAINER
CONTAINERS
CONTAINS
CONTENT
CONTEXT
CONTINUE
CONTINUOUSLY
CONTROL
CONVERT
COORDINATOR
COPY
CORRELATOR
COUNT
COUNT_BIG
CPU
CPUTIME
CPUTIMEINSC
CREATE
CREATEIN
CREATETAB
CREATE_EXTERNAL_ROUTINE
CREATE_NOT_FENCED
CREATE_NOT_FENCED_ROUTINE
CROSS
CS
CUBE
CURRENT
CURRENT_DATE
CURRENT_PATH
CURRENT_SCHEMA
CURRENT_SERVER
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TIMEZONE
CURRENT_USER
CURRVAL
CURSOR
CURSORS
CYCLE
DATA
DATAACCESS
DATABASE
DATE
DAY
DAYS
DB
DB2DARI
DB2GENERAL
DB2GENRL
DB2LBACREADARRAY
DB2LBACREADSET
DB2LBACREADTREE
DB2LBACRULES
DB2LBACWRITEARRAY
DB2LBACWRITESET
DB2LBACWRITETREE
DB2SECURITYLABEL
DB2SPL
DB2SQL
DB2VALIDATE
DB2_RETURN_STATUS
DB2_TOKEN_STRING
DBADM
DBCLOB
DBINFO
DBMEMUSE
DBPARTITIONNUM
DBPARTITIONNUMS
DBPARTITIONS
DDL
DEACTIVATE
DEADLOCK
DEADLOCKS
DEBUGINFO
DEC
DECFLOAT
DECIMAL
DECLARE
DECOMPOSITION
DEFAULT
DEFAULTS
DEFER
DEFERRED
DEFINE
DEFINITION
DEGREE
DELETE
DEPENDENT
DESC
DESCRIPTOR
DETACH
DETAILED
DETAILS
DETERMINED
DETERMINISTIC
DEVICE
DIAGNOSTICS
DIMENSIONS
DIRTY
DISABLE
DISABLED
DISALLOW
DISPATCH
DISTINCT
DISTRIBUTE
DISTRIBUTED
DISTRIBUTION
DLCONN
DLLOCK
DML
DO
DOCUMENT
DOUBLE
DROP
DROPIN
DROPPED
DYNAMIC
EACH
ELEMENT
ELSE
ELSEIF
EMPTY
ENABLE
ENABLED
ENCRYPTION
END
ENDING
ENFORCED
ENFORCEMENT
ENVIRONMENT
ERASE
ERROR
ESCALATION
ESCAPE
ESTIMATE
ESTIMATEDCOST
ESTIMATEDSQLCOST
EUR
EVALUATE
EVENT
EVERY
EXACT
EXCEEDED
EXCEPT
EXCEPTION
EXCLUDE
EXCLUDES
EXCLUDING
EXCLUSIVE
EXECNODE
EXECUTE
EXECUTETIME
EXECUTION
EXEMPTION
EXISTS
EXIT
EXPAND
EXPLAIN
EXPRESSION
EXTEND
EXTENDED
EXTENSION
EXTENTSIZE
EXTERNAL
EXTRACT
FAILURE
FALSE
FEDERATED
FEDERATED_TOOL
FENCED
FETCH
FILE
FILEREAD
FILEWRITE
FILTER
FINAL
FIRST
FLOAT
FLUSH
FOLLOWING
FOR
FORCE
FOREIGN
FOUND
FREE
FREEPAGE
FROM
FULL
FUNCTION
G
GBPCACHE
GENERAL
GENERATE
GENERATED
GET
GLOBAL
GOTO
GRANT
GRAPHIC
GROUP
GROUPING
HANDLER
HARD
HASH
HASHED
HASHING
HAVING
HEX
HIDDEN
HIERARCHY
HIGH
HISTOGRAM
HISTOGRAMBIN
HISTORY
HOLD
HOUR
HOURS
HPJ
IDENTITY
IF
IGNORE
IMMEDIATE
IMPLICIT
IMPLICITLY
IMPLICIT_SCHEMA
IN
INBOUND
INCLUDE
INCLUDES
INCLUDING
INCLUSIVE
INCREASESIZE
INCREMENT
INCREMENTAL
INDEX
INDEXES
INDICATOR
INF
INFINITY
INFIX
INFO
INHERIT
INITIALLY
INITIALSIZE
INITIAL_INSTS
INITIAL_IOS
INLINE
INLINEFUNCTION
INLINETRIGGER
INNER
INOUT
INPUT
INSENSITIVE
INSERT
INSTANTIABLE
INSTEAD
INSTS_PER_ARGBYTE
INSTS_PER_INVOC
INT
INTACT
INTEGER
INTEGRITY
INTERARRIVALTIME
INTERSECT
INTO
INVALID
INVALIDATION
IO
IOS_PER_ARGBYTE
IOS_PER_INVOC
IS
ISO
ISOLATION
ITEM
ITERATE
JAVA
JIS
JOIN
K
KEEP
KEY
KEYS
L
LABEL
LANGUAGE
LARGE
LAST
LATERAL
LC_CTYPE
LC_MESSAGES
LC_TIME
LEADING
LEAVE
LEFT
LENGTH
LEVEL
LEVEL2
LIBRARY
LIBRARYADM
LIFETIME
LIKE
LIMIT
LIST
LOAD
LOCAL
LOCALE
LOCATION
LOCATOR
LOCATORS
LOCK
LOCKED
LOCKING
LOCKS
LOCKSIZE
LOG
LOGGED
LONG
LONGVAR
LOOP
LOW
LOWER
M
MAIN
MAINTAINED
MANAGED
MANUALSTART
MAP
MAPPING
MARK
MATCHED
MATCHING
MATERIALIZED
MAX
MAXFILES
MAXFILESIZE
MAXSIZE
MAXVALUE
MDC
MEDIUM
MERGE
MESSAGE_TEXT
METHOD
METHODS
METRICS
MICROSECOND
MICROSECONDS
MINPCTUSED
MINUS
MINUTE
MINUTES
MINVALUE
MISSING
MIXED
MODE
MODIFIES
MODULE
MONITOR
MONTH
MONTHS
MORE
MOVEMENT
NAMESPACE
NAN
NESTED
NETWORK
NEW
NEW_TABLE
NEXT
NEXTVAL
NICKNAME
NO
NOCACHE
NOCYCLE
NODE
NODEGROUP
NODES
NOMAXVALUE
NOMINVALUE
NONBLOCKED
NONE
NOORDER
NORMAL
NOT
NULL
NULLS
NUM
NUMBER
NUMBLOCKPAGES
NUMERIC
NUM_EXECUTIONS
NUM_FREQVALUES
NUM_QUANTILES
OBJECT
OBJMAINT
OCCURRENCE
OCTETS
OF
OFF
OLD
OLD_TABLE
OLE
OLEDB
ON
ONCE
ONLINE
ONLY
OPEN
OPTIMIZATION
OPTIMIZE
OPTION
OPTIONS
OPTPROFILE
OR
ORDER
ORDINALITY
ORGANIZE
OUT
OUTBOUND
OUTER
OVER
OVERFLOW
OVERHEAD
OVERRIDE
OVERRIDING
OWNERSHIP
P
PACKAGE
PAGE
PAGESIZE
PARALLEL
PARAMETER
PARAMETERS
PART
PARTITION
PARTITIONED
PARTITIONING
PARTITIONINGS
PARTITIONS
PASSING
PASSTHRU
PASSWORD
PATH
PATHS
PATROLLER
PCTDEACTIVATE
PCTFREE
PENDING
PERCENT
PERCENT_ARGBYTES
PERFORM
PIECESIZE
PIPE
PLACING
PLAN
POLICY
POSITION
PRECEDING
PRECISION
PREDICATES
PREFETCH
PREFETCHSIZE
PREPARE
PRESERVE
PREVENT
PREVIOUS
PREVVAL
PRIMARY
PRIOR
PRIORITY
PRIQTY
PRIVILEGES
PROCEDURE
PROFILE
PROGRAM
PROPAGATE
PROTOCOL
PRUNE
PUBLIC
PUBLISH
QSTATS
QUERY
QUERYNO
QUERYTAG
QUEUEDACTIVITIES
QUEUEDCONNECTIONS
QUEUETIME
QUIESCED
QUIESCE_CONNECT
RANGE
RATE
RATIO
READ
READS
REAL
REBALANCE
RECOMMEND
RECORD
RECOVERY
RECREATE
REDIRECT
REDUCE
REF
REFERENCE
REFERENCES
REFERENCING
REFRESH
REGISTERS
REGULAR
REJECT
RELEASE
REMAIN
REMAP
REMOTE
REMOVE
RENAME
REOPT
REPEAT
REPEATABLE
REPLACE
REPLICATED
REPLICATION
REQUEST
REQUIRE
RESET
RESIDENT
RESIGNAL
RESIZE
RESOLVE
RESTART
RESTORE
RESTRICT
RESULT
RESULT_SET_LOCATOR
RETAIN
RETURN
RETURNING
RETURNS
RETURN_STATUS
REUSE
REVERSE
REVOKE
RID
RID_BIT
RIGHT
ROLE
ROLLBACK
ROLLOUT
ROLLUP
ROOT
ROUNDING
ROUND_CEILING
ROUND_DOWN
ROUND_FLOOR
ROUND_HALF_EVEN
ROUND_HALF_UP
ROUTINE
ROUTINES
ROW
ROWS
ROW_COUNT
RR
RS
RULE
RUN
S
SAFE
SAMPLED
SAVEPOINT
SBCS
SCANS
SCHEMA
SCOPE
SCRATCHPAD
SCROLL
SCSTATS
SEARCH
SECADM
SECMAINT
SECOND
SECONDS
SECQTY
SECTION
SECURED
SECURITY
SELECT
SELECTION
SELECTIVITY
SELF
SENSITIVE
SEQUENCE
SERIALIZABLE
SERVER
SERVICE
SESSION
SESSION_USER
SET
SETS
SETSESSIONUSER
SETTING
SHARE
SHRLEVEL
SIBLINGS
SIGNAL
SIMPLE
SINGLE
SIZE
SKIP
SMALLINT
SNAN
SNAPSHOT
SOFT
SOME
SOURCE
SPECIAL
SPECIFIC
SPECIFICATION
SPLIT
SQL
SQLADM
SQLCODE
SQLDATA
SQLERROR
SQLEXCEPTION
SQLID
SQLINTERNAL
SQLMACRO
SQLROWSREAD
SQLROWSREADINSC
SQLROWSRETURNED
SQLSTATE
SQLTEMPSPACE
SQLWARNING
SQL_CCFLAGS
SSA
STABILITY
STAGING
START
STARTING
STATE
STATEMENT
STATEMENTS
STATIC
STATISTICS
STATUS
STAY
STMT
STMTHIST
STMTVALS
STMT_EXEC_TIME
STOGROUP
STOP
STORAGE
STORE
STRING
STRINGS
STRIP
STRIPE
STYLE
SUB
SUBSECTION
SUCCESS
SUMMARY
SWITCH
SYMMETRIC
SYNONYM
SYSADM
SYSADMIN
SYSCTRL
SYSCURSOR
SYSDATE
SYSMAINT
SYSMON
SYSPROC
SYSTEM
SYSTEM_USER
T
TABLE
TABLES
TABLESAMPLE
TABLESPACE
TABLESPACES
TARGET
TEMPLATE
TEMPORARY
THAN
THEN
THREADSAFE
THRESHOLD
THRESHOLDVIOLATIONS
THROUGH
TIME
TIMEOUT
TIMERONCOST
TIMESTAMP
TIMEZONE
TO
TOKEN
TOTALDBPARTITIONCONNECTIONS
TOTALSCPARTITIONCONNECTIONS
TRAILING
TRANSACTIONS
TRANSFER
TRANSFERRATE
TRANSFORM
TRANSFORMS
TRANSLATE
TREAT
TREE
TRIGGER
TRIGGERS
TRIM
TRUE
TRUNC
TRUNCATE
TRUSTED
TWOLEVEL
TYPE
TYPES
UESCAPE
UNBOUNDED
UNCHECKED
UNCOMMITTED
UNDER
UNDO
UNFORMATTED
UNICODE
UNION
UNIQUE
UNIT
UNITS
UNNEST
UNQUIESCED
UNSAFE
UNTIL
UOWTOTALTIME
UPDATE
UPDATED_SINCE_BOUNDARY_TIME
UPON
UR
URI
USA
USAGE
USE
USER
USERID
USING
VALIDATE
VALIDATED
VALUE
VALUES
VARCHAR
VARCHAR2
VARGRAPHIC
VARIABLE
VARIANT
VARYING
VCAT
VERSION
VIEW
VIOLATIONS
VOLATILE
WAIT
WAITING
WATER
WCSTATS
WHEN
WHERE
WHILE
WHITESPACE
WITH
WITHIN
WITHOUT
WITHSCHEMA
WLMADM
WLSTATS
WORK
WORKLOAD
WRAPPER
WRITE
WRITEDOWN
WRITEUP
WRKSTNNAME
XACT
XML
XMLAGG
XMLATTRIBUTES
XMLBINARY
XMLCAST
XMLCOMMENT
XMLCONCAT
XMLDECLARATION
XMLDOCUMENT
XMLELEMENT
XMLEXISTS
XMLFOREST
XMLGROUP
XMLNAMESPACES
XMLPARSE
XMLPATTERN
XMLPI
XMLQUERY
XMLROW
XMLSCHEMA
XMLSERIALIZE
XMLTABLE
XMLTEXT
XMLVALIDATE
XPATH
XQUERY
XSLTRANSFORM
XSROBJECT
YEAR
YEARS
YES