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 Universal Database⢠for iSeriesā¢, V5R4:
ABSOLUTE
ACCESS
ACTION
ACTIVATE
ADA
ADD
AFTER
AGE
ALIAS
ALL
ALLOCATE
ALLOW
ALTER
ALTERIN
ALWAYS
AND
ANY
APPEND
APPL_ID
APPL_NAME
ARE
AS
ASC
ASCII
ASSERTION
ASSIGNMENT
ASSOCIATE
AST
ASUTIME
AT
ATOMIC
ATTRIBUTE
ATTRIBUTES
AUTHORIZATION
AUTH_ID
AUTHID
AUTOMATIC
AUTOSTART
AVG
BEFORE
BEGIN
BETWEEN
BIGINT
BINARY
BIND
BINDADD
BIT
BIT_LENGTH
BLOB
BLOCKED
BOTH
BUFFER
BUFFERPOOL
BUFFERPOOLS
BUFFERSIZE
BY
C
CACHE
CALL
CALLED
CALLER
CAPTURE
CARDINALITY
CASCADE
CASCADED
CASE
CAST
CATALOG
CATALOG_NAME
CHANGE
CHANGED
CHANGES
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHARACTER_SET_CATALOG
CHARACTER_SET_NAME
CHARACTER_SET_SCHEMA
CHECK
CHECKED
CL
CLASS_ORIGIN
CLIENT
CLOB
CLOSE
CLUSTER
COBOL
COBOLLE
COLLATE
COLLATION
COLLATION_CATALOG
COLLATION_NAME
COLLATION_SCHEMA
COLLECT
COLLID
COLUMN
COLUMNS
COLUMN_NAME
COMM
COMMAND_FUNCTION
COMMENT
COMMIT
COMMITTED
COMPACT
COMPARISONS
CONCAT
CONDITION
CONDITION_NUMBER
CONNECT
CONNECTION
CONNECTIONS
CONNECTION_NAME
CONNECTOPT
CONSERVATIVE
CONSTRAINT
CONSTRAINT_CATALOG
CONSTRAINT_NAME
CONSTRAINT_SCHEMA
CONSTRAINTS
CONTAINERS
CONTAINS
CONTINUE
CONTROL
CONVERT
COPY
CORRELATION
CORR
CORRESPONDING
COUNT
COUNT_BIG
CPU
C++
CREATE
CREATEIN
CREATE_NOT_FENCED
CREATETAB
CROSS
CUBE
CURRENT
CURRENT_DATE
CURRENT_DEGREE
CURRENT_EXECNODE
CURRENT_EXPLAIN_MODE
CURRENT_EXPLAIN_SNAPSHOT
CURRENT_FUNCTION_PATH
CURRENT_NODE
CURRENT_PATH
CURRENT_QUERY_OPTIMIZATION
CURRENT_REFRESH_AGE
CURRENT_SCHEMA
CURRENT_SERVER
CURRENT_SQLID
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TIMEZONE
CURRENT_USER
CURRVAL
CURSOR
CURSORS
CURSOR_NAME
CYCLE
DATE
DATA
DATABASE
DATALINK
DATETIME_INTERVAL_CODE
DATETIME_INTERVAL_PRECISION
DAY
DAYS
DB
DBADM
DBCLOB
DBINFO
DB2DARI
DB2GENRL
DB2GENERAL
DB2OPTIONS
DB2SQL
DEADLOCKS
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFAULTS
DEFINE
DEFINITION
DEGREE
DEFER
DEFERRABLE
DEFERRED
DELETE
DESC
DESCRIBE
DESCRIPTOR
DETAILED
DETERMINISTIC
DEVICE
DIAGNOSTICS
DIMENSIONS
DISABLE
DISALLOW
DISCONNECT
DISPATCH
DISTINCT
DISTRIBUTION
DOMAIN
DO
DOUBLE
DROP
DROPIN
DROPPED
DYNAMIC
DYNAMIC_FUNCTION
EACH
EBCDIC
ELSE
ELSEIF
EMPTY
ENABLE
END
END-EXEC
ERASE
ESCAPE
EUR
EVALUATE
EVENT
EXACT
EXCEPT
EXCEPTION
EXCLUDE
EXCLUDING
EXCLUSIVE
EXEC
EXECNODE
EXECUTE
EXISTS
EXIT
EXPAND
EXPLAIN
EXPRESSION
EXTEND
EXTENDED
EXTENSION
EXTENTSIZE
EXTERNAL
EXTRACT
FALSE
FEDERATED
FENCED
FETCH
FILE
FILTER
FINAL
FIRST
FLOAT
FLUSH
FOLLOWING
FOR
FORCE
FOREIGN
_FOREIGNKEY
FORTRAN
FOUND
FREEPAGE
FROM
FS
FULL
FUNCTION
G
GBPCACHE
GENERAL
GENERATE
GENERATED
GET
GLOBAL
GO
GOTO
GRANT
GRAPHIC
GROUP
GROUPING
HANDLER
HASHING
HAVING
HIDDEN
HIERARCHY
HPJ
HOLD
HOUR
HOURS
ID
IDENTITY
IF
IMMEDIATE
IMPLICIT_SCHEMA
IN
INCLUDE
INCLUDING
INCREMENT
INCREMENTAL
INDEX
INDEXES
INDICATOR
INFIX
INHERIT
INITIALLY
INITIAL_INSTS
INITIAL_IOS
INLINE
INNER
INOUT
INPUT
INSENSITIVE
INSERT
INSTANTIABLE
INSTEAD
INSTS_PER_ARGBYTE
INSTS_PER_INVOC
INT
INTEGER
INTEGRITY
INTERSECT
INTERVAL
INTO
IO
IOS_PER_ARGBYTE
IOS_PER_INVOC
IS
ISO
ITERATE
ISOLATION
JAVA
JAVA_V50
JIS
JOIN
K
KEY
KEYS
LANGUAGE
LARGE
LAST
LEADING
LEAVE
LEFT
LENGTH
LEVEL
LIBRARY
LIKE
LIMIT
LINK
LINKTYPE
LOAD
LOCAL
LOCATOR
LOCATORS
LOCK
LOCKS
LOCKSIZE
LOGGED
LONG
LONGVAR
LOOP
LOWER
M
MAINTAINED
MAIN_PROG
MANAGED
MANUALSTART
MAPPING
MATCH
MAX
MAXFILES
MAXFILESIZE
MAXVALUE
MESSAGE_LENGTH
MESSAGE_OCTET_LENGTH
MESSAGE_TEXT
METHOD
METHODS
MICROSECOND
MICROSECONDS
MINPCTUSED
MINUTE
MINUTES
MINVALUE
MIXED
MODE
MODIFIES
MODULE
MONITOR
MONTH
MONTHS
MORE
MUMPS
NAME
NAMES
NATIONAL
NATURAL
NCHAR
NEW
NEW_TABLE
NEXT
NEXTVAL
NICKNAME
NO
NOCACHE
NOCYCLE
NODE
NODES
NODEGROUP
NOMAXVALUE
NOMINVALUE
NONBLOCKED
NONE
NOORDER
NOT
NULL
NULLABLE
NULLCALL
NULLS
NUM
NUMBER
NUMERIC
NUM_FREQVALUES
NUM_QUANTILES
OCTET_LENGTH
OBJECT
OF
OFF
OLD
OLD_TABLE
OLE
OLEDB
ON
ONCE
ONLINE
ONLY
OPEN
OPTIMIZATION
OPTIMIZE
OPTION
OPTIONS
OR
ORDER
OUT
OUTER
OUTPUT
OVER
OVERHEAD
OVERLAPS
P
PACKAGE
PAD
PAGESIZE
PARTIAL
PARALLEL
PARALLELISM
PARAMETER
PASCAL
PASSTHRU
PASSWORD
PATH
PARTITION
PARTITIONING
PARTITIONINGS
PCTFREE
PENDING
PERCENT_ARGBYTES
PERMISSION
PIECESIZE
PIPE
PLAN
PLI
POSITION
PRECEDING
PRECISION
PREDICATE
PREDICATES
PREFETCHSIZE
PREPARE
PRESERVE
PRIMARY
_PRIMARYKEY
PRIOR
PRIQTY
PRIVILEGES
PROCEDURE
PROGRAM
PROPAGATE
PROTOCOL
PUBLIC
QUERY
QUERYNO
QUERYTAG
RANGE
RATE
RATIO
READ
READS
REAL
RECOMMEND
RECONCILE
RECOVERY
RECREATE
REF
REFERENCE
REFERENCES
REFERENCING
REFRESH
REGISTERS
REGULAR
RELATIVE
RELEASE
REMAIN
REMOTE
RENAME
REPEATABLE
REPEAT
RPG
RPGLE
REPLACE
REPLICATED
RESET
RESIDENT
RESIGNAL
RESIZE
RESOLVE
RESTART
RESTORE
RESTRICT
RESULT
RESULT_SET_LOCATOR
RETURNED_LENGTH
RETURNED_OCTET_LENGTH
RETURNED_SQLSTATE
RETAIN
RETURN
RETURNS
RETURN_STATUS
REVERSE
REVOKE
RIGHT
ROLLBACK
ROLLUP
ROUTINE
ROW
ROW_COUNT
ROWID
ROWS
RUN
S
SAMPLE
SAMPLED
SAVEPOINT
SBCS
SCALE
SCANS
SCHEMA
SCHEMA_NAME
SCOPE
SCRATCHPAD
SCROLL
SEARCH
SECOND
SECONDS
SECQTY
SECTION
SELECT
SELECTION
SELECTIVE
SELECTIVITY
SELF
SEQUENCE
SERIALIZABLE
SERVER
SERVER_NAME
SESSION
SESSION_USER
SET
SETS
SETTING
SHARE
SHRLEVEL
SIGNAL
SIMPLE
SIZE
SMALLINT
SNAPSHOT
SOME
SOURCE
SPACE
SPECIAL
SPECIFIC
SPECIFICATION
SQL
SQLCODE
SQLERROR
SQLEXCEPTION
SQLWARNING
SQLID
SQLMACRO
SQLSTATE
STAGING
START
STATE
STATEMENT
STATEMENTS
STATISTICS
STAY
STOGROUP
STORAGE
STORED
STYLE
SUB
SUBCLASS_ORIGIN
SUBSTRING
SUMMARY
SWITCH
SYNONYM
SYSTEM
SYSTEM_USER
TABLE
TABLES
TABLE_NAME
TABLESPACE
TABLESPACES
TARGET
TEMPLATE
TEMPORARY
THEN
THREADSAFE
THROUGH
TIME
TIMESTAMP
TIMEZONE
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TRAILING
TRANSACTION
TRANSACTIONS
TRANSFERRATE
TRANSFORM
TRANSFORMS
TRANSLATE
TRANSLATION
TREAT
TRIGGER
TRIM
TRUE
TYPE
UNBOUNDED
UNCHECKED
UNCOMMITTED
UNDER
UNDO
UNICODE
UNION
UNIQUE
UNKNOWN
UNLINK
UNTIL
UNNAMED
UPDATE
UPPER
URL
USA
USE
USAGE
USER
USING
VALUE
VALUES
VARCHAR
VARGRAPHIC
VARIANT
VARYING
VCAT
VERSION
VIEW
VOLATILE
WHEN
WHENEVER
WHERE
WHILE
WITH
WITHOUT
WORK
WRAPPER
WRITE
YEAR
YEARS
YES
ZEROES
ZONE