The DB2 Universal Database™ for z/OS® V9 includes the generated data model that has all the new catalog features specified in the new function mode. This back-end enables the option to work with the generated data model available in the WebSphere® Application Server Toolkit or IBM® Rational® Software Development Platform products.
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 z/OS, V9:
ABSOLUTE
ACCESS
ACTION
ACTIVATE
ADA
ADD
AFTER
ALIAS
ALL
ALLOCATE
ALLOW
ALTER
ALTERIN
ALWAYS
AND
ANY
APPEND
ARE
AS
ASC
ASCII
ASSERTION
ASSOCIATE
ASUTIME
AT
ATOMIC
ATTRIBUTES
AUTHORIZATION
AUTHID
AUTOMATIC
AVG
BEFORE
BEGIN
BETWEEN
BINARY
BIND
BINDADD
BIT
BIT_LENGTH
BLOB
BLOCKED
BOTH
BUFFERPOOL
BUFFERPOOLS
BY
C
CACHE
CALL
CALLED
CALLER
CAPTURE
CARDINALITY
CASCADE
CASCADED
CASE
CAST
CATALOG
CATALOG_NAME
CHANGE
CHANGED
CHANGES
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHECK
CHECKED
CLIENT
CLOB
CLOSE
CLUSTER
COBOL
COLLATE
COLLATION
COLLECT
COLLID
COLUMN
COMMENT
COMMIT
COMMITTED
COMPARISONS
CONCAT
CONDITION
CONDITION_NUMBER
CONNECT
CONNECTION
CONNECTION_NAME
CONSERVATIVE
CONSTRAINT
CONSTRAINTS
CONTAINS
CONTINUE
CONTROL
CONVERT
COPY
CORRELATION
CORR
CORRESPONDING
COUNT
COUNT_BIG
CPU
C++
CREATE
CREATEIN
CREATETAB
CROSS
CUBE
CURRENT
CURRENT_DATE
CURRENT_PATH
CURRENT_SCHEMA
CURRENT_SERVER
CURRENT_SQLID
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TIMEZONE
CURRENT_USER
CURSOR
CURSORS
CURSOR_NAME
CYCLE
DATE
DATA
DATABASE
DATALINK
DAY
DAYS
DB
DBADM
DBCLOB
DBINFO
DB2DARI
DB2GENRL
DB2GENERAL
DB2SQL
DEADLOCKS
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFAULTS
DEFINE
DEFINITION
DEGREE
DEFER
DEFERRABLE
DEFERRED
DELETE
DESC
DESCRIBE
DESCRIPTOR
DETERMINISTIC
DIAGNOSTICS
DIMENSIONS
DISABLE
DISALLOW
DISCONNECT
DISPATCH
DISTINCT
DOMAIN
DO
DOUBLE
DROP
DROPIN
DYNAMIC
EACH
EBCDIC
ELSE
ELSEIF
EMPTY
ENABLE
END
END-EXEC
ERASE
ESCAPE
EUR
EVENT
EXACT
EXCEPT
EXCEPTION
EXCLUDE
EXCLUDING
EXCLUSIVE
EXEC
EXECUTE
EXISTS
EXIT
EXPLAIN
EXTENDED
EXTENSION
EXTERNAL
EXTRACT
FALSE
FEDERATED
FENCED
FETCH
FILE
FINAL
FIRST
FLOAT
FLUSH
FOLLOWING
FOR
FORCE
FOREIGN
FORTRAN
FOUND
FREEPAGE
FROM
FS
FULL
FUNCTION
G
GBPCACHE
GENERAL
GENERATE
GENERATED
GET
GLOBAL
GO
GOTO
GRANT
GRAPHIC
GROUP
GROUPING
HANDLER
HAVING
HOLD
HOUR
HOURS
IDENTITY
IF
IMMEDIATE
IMPLICIT_SCHEMA
IN
INCLUDE
INCLUDING
INCREMENT
INDEX
INDEXES
INDICATOR
INHERIT
INITIALLY
INITIAL_INSTS
INITIAL_IOS
INNER
INOUT
INPUT
INSENSITIVE
INSERT
INSTEAD
INSTS_PER_ARGBYTE
INSTS_PER_INVOC
INT
INTEGER
INTEGRITY
INTERSECT
INTERVAL
INTO
IOS_PER_ARGBYTE
IOS_PER_INVOC
IS
ISO
ITERATE
ISOLATION
JAVA
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
MAPPING
MATCH
MAX
MAXVALUE
MESSAGE_TEXT
METHOD
MICROSECOND
MICROSECONDS
MINUTE
MINUTES
MINVALUE
MIXED
MODE
MODIFIES
MODULE
MONITOR
MONTH
MONTHS
MORE
NAMED
NAMES
NATIONAL
NATURAL
NCHAR
NEW
NEW_TABLE
NEXT
NEXTVAL
NICKNAME
NO
NOCACHE
NOCYCLE
NODE
NOMAXVALUE
NOMINVALUE
NONE
NOORDER
NOT
NULL
NULLABLE
NULLS
NUMBER
NUMERIC
OBJECT
OF
OFF
OLD
OLD_TABLE
OLE
OLEDB
ON
ONCE
ONLINE
ONLY
OPEN
OPTIMIZATION
OPTIMIZE
OPTION
OPTIONS
OR
ORDER
OUT
OUTER
OUTPUT
OVER
OVERLAPS
PACKAGE
PAD
PARTIAL
PARALLEL
PARAMETER
PASCAL
PASSTHRU
PASSWORD
PATH
PARTITION
PARTITIONING
PCTFREE
PERCENT_ARGBYTES
PERMISSION
PIECESIZE
PIPE
PLAN
PLI
POSITION
PRECEDING
PRECISION
PREPARE
PRESERVE
PRIMARY
PRIOR
PRIQTY
PRIVILEGES
PROCEDURE
PROGRAM
PROTOCOL
PUBLIC
QUERY
QUERYNO
RANGE
READ
READS
REAL
RECOMMEND
RECOVERY
REF
REFERENCE
REFERENCES
REFERENCING
REFRESH
REGISTERS
RELATIVE
RELEASE
RENAME
REPEATABLE
REPEAT
REPLACE
REPLICATED
RESET
RESIDENT
RESIGNAL
RESOLVE
RESTART
RESTORE
RESTRICT
RESULT
RESULT_SET_LOCATOR
RETURNED_SQLSTATE
RETAIN
RETURN
RETURNS
RETURN_STATUS
REVOKE
RIGHT
ROLLBACK
ROLLUP
ROUTINE
ROW
ROW_COUNT
ROWID
ROWS
RUN
S
SAVEPOINT
SBCS
SCALE
SCHEMA
SCOPE
SCRATCHPAD
SCROLL
SEARCH
SECOND
SECONDS
SECQTY
SECTION
SELECT
SELECTIVITY
SELF
SEQUENCE
SERIALIZABLE
SERVER
SERVER_NAME
SESSION
SESSION_USER
SET
SETS
SHARE
SHRLEVEL
SIGNAL
SIMPLE
SIZE
SMALLINT
SNAPSHOT
SOME
SOURCE
SPACE
SPECIAL
SPECIFIC
SQL
SQLCODE
SQLERROR
SQLEXCEPTION
SQLWARNING
SQLID
SQLSTATE
START
STATE
STATEMENT
STATISTICS
STAY
STOGROUP
STORAGE
STORED
STYLE
SUB
SUBSTRING
SUMMARY
SWITCH
SYNONYM
SYSTEM
SYSTEM_USER
TABLE
TABLES
TABLE_NAME
TABLESPACE
TABLESPACES
TEMPLATE
TEMPORARY
THEN
THREADSAFE
TIME
TIMESTAMP
TIMEZONE
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TRAILING
TRANSACTION
TRANSFORM
TRANSLATE
TRANSLATION
TREAT
TRIGGER
TRIM
TRUE
TYPE
UNBOUNDED
UNCOMMITTED
UNDER
UNDO
UNICODE
UNION
UNIQUE
UNKNOWN
UNTIL
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
ZONE